Converting Azure SQL to MySQL
I am a fairly new developer working on a database for a university research project. I created a database in Microsoft Access and then used the SSMA Access to SQL migration tool to export to Azure SQL. I am now building a front end database Ruby on Rails implementation on VBS Debian and would like to migrate Azure SQL Database to MySQL for testing purposes with the goal of finally converting all database ends to MySQL database connectivity.
I was able to find many articles about migrating MySQL to Azure SQL, but very few that detail the process in reverse. Any help would be appreciated!
Thank,
Mike
source to share
Mysql allows you to import full database dumps (table definitions and content), if they are in sql format, in a text file.
As long as you manage to dump your database as a text file of sql statements, you should be fine.
The only thing that azure means can't give you a chance to create this dump. But you will likely have third party tools that will allow you.
If not, since you originally created your database in the public domain, you will surely find free tools to access mysql migrations. (A quick Google search shows me bullzip and mdbtools as two free tools that do just that.)
After your sql dump file just import it to mysql from command line or using source command in mysql client.
source to share