Share via

Data Sync between Open source MySQL to Azure SQL

Sarvesh Pandey 141 Reputation points
2021-05-24T12:06:31.837+00:00

Is it possible to setup continuous data sync between On-premise MySQL to Azure SQL or Azure MySQL to Azure SQL DB.

Data migration blog is helpful when one has to do Lift & Shift migration rather then continuous Sync.

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
848 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 34,056 Reputation points MVP
    2021-05-24T13:51:54.507+00:00

    Currently SQL Data Sync service only works with Azure SQL Databases, SQL Server, SQL Express and LocalDB databases.

    However you can use Sync Framework to build your own solution. Please read this article to know how. This is another related article. If you finally decide to build your own implementation of Azure Data Sync please take in consideration these recommendations.

    Another option you have is to sync between a MySQL (on-premises) and a subordinate server running on MySQL Database on Azure. See this documentation.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.