question

SarveshPandey-7139 avatar image
0 Votes"
SarveshPandey-7139 asked OuryBa-MSFT commented

Data Sync between Open source MySQL to Azure SQL

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-databaseazure-database-mysql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SarveshPandey-7139 Did the answer below provided by Morillo helpful. Please feel free to reach out if you further query.
Regards
Oury

0 Votes 0 ·

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.