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?
Asked
Active
Viewed 393 times
0
-
Does "my SQL" DB mean MySQL db? Or just your db? (Big difference.) – jarlh May 16 '19 at 07:10
-
It is MySQL db. – Prathyusha Dwibhashi May 16 '19 at 07:17
-
Do you want to copy data from Azure SQL database to on-premise MySQL DB? – Leon Yue May 16 '19 at 08:13
-
Yes.and any changes in Azure SQL table should be reflected in MYSQL DB table always. – Prathyusha Dwibhashi May 16 '19 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 May 16 '19 at 20:21
-
Hi Prathyusha Dwibhashi, you can use MySQL Workbench Migration , Amazon DMS or Data Integration (Kettle). please see my update. – Leon Yue May 23 '19 at 10:09
1 Answers
2
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.
Leon Yue
- 15,693
- 1
- 11
- 23