Is there any possibility to export and create a link between one of the table from Azure SQL DB to the table in MySQL DB?
6
-
Does "my SQL" DB mean MySQL db? Or just your db? (Big difference.)jarlh– jarlh2019-05-16 07:10:01 +00:00Commented May 16, 2019 at 7:10
-
It is MySQL db.Prathyusha Dwibhashi– Prathyusha Dwibhashi2019-05-16 07:17:24 +00:00Commented May 16, 2019 at 7:17
-
Do you want to copy data from Azure SQL database to on-premise MySQL DB?Leon Yue– Leon Yue2019-05-16 08:13:03 +00:00Commented May 16, 2019 at 8:13
-
Yes.and any changes in Azure SQL table should be reflected in MYSQL DB table always.Prathyusha Dwibhashi– Prathyusha Dwibhashi2019-05-16 10:30:30 +00:00Commented May 16, 2019 at 10:30
-
1I would go back to the drawing board and review this architecture.If what you need is daily backups and a db where you can have those backups running (kind of copy of production for dev environment), you can automate this in many different ways.Rafa– Rafa2019-05-16 20:21:33 +00:00Commented May 16, 2019 at 20:21
|
Show 1 more comment
1 Answer
Firstly, you can migrate data from SQL server to your MySQL database. And there are many ways can help you achieve that. You can reference this blog :How to migrate SQL Server database to MySQL?.
But for Azure, you could not copy or migrate data from Azure SQL database to your on-premise MySQL DB, even with Azure Data Factory. Azure Data Factory only support MySQL as source server.
Secondly, You want to sync the data between Azure SQL database and your MySQL database. Azure SQL Data Sync only support Azure SQL Database and on-premise SQL Server instance.
This means that Azure could not help you migrate or sync data from Azure SQL data base to MySQL DB. You have to use third-party tools.
One of the ways is you can use MySQL Workbench Migration tool. Database migrations - enables migrations from Microsoft SQL Server, Microsoft Access, PostgreSQL, Sybase ASE, Sybase SQL Anywhere, SQLite, and more.
There are many tools to perform the migration from MS SQL Server to MySQL like Amazon DMS or Data Integration (Kettle), but in this case, we’ll use the MySQL Workbench Migration tool.
Please reference this tutorial: How to Migrate from MSSQL to MySQL.
Hope this helps.
