In the previous posts, we saw how to download and install SQL Server Migration Assistant for MySQL v5.0 and configure utility database, and how to create a new migration project, add MySQL databases and SQL Server databases for conversion, analyze and prepare migration report.
In this post we will how to synchronize the MySQL schema to SQL Azure database and then migrate data
To convert the MySQL schema to SQL Azure schema, select the source database “ClassicModels” in MySQL Metadata Explorer and the right click and click on “Convert Schema”
Once the schema is converted, we will get the messages in output window similar to this (Messages will vary based on your database), if the message returns any error we need to fix it before migration
Once the schema conversion is complete, to migrate the schema, Right click on Target database in SQL Azure Metadata explorer and click on “Synchronize with Database”
Specify the password for the target server and click “Connect”
The schema migration preview window will display the list of objects being migrated, Click “Ok” to proceed
Migration process will be displayed in Output window, Once complete the output window will display the below message
Now we have successfully migrated the schema, To migrate the data, right click on Source Database and click “Migrate Data”
Specify the MySQL Server credentials and click “Connect”
Specify SQL Azure Target server credentials and click “Connect” to proceed
The data migrations process will prepare the data and start uploading the data to SQL Azure, the process details will be displayed in output window and the following message and below Data Migration Report will be displayed once the data migration completes successfully.
You can save the Data Migration report as CSV file for your reference.
You can connect to SQL Azure server using Project Houston or SQL Server Management Studio and query the data
Now we have successfully migrated the database schema and data from MySQL database to SQL Azure
Hope you all find this information useful !!!
2 thoughts on “Migrating MySQL Databases to SQL Azure using SSMA–Part 3”
I can do everything successfully up until I the migrate data. It fails on every table without any error or warning messages…so frustrating. Any suggestions?
Can you please verify the following ?
1. Database and Schema mapped correctly
2. Whether Create Report doesn’t throw any errors ?
3. User name connecting to MySQL has permissions to SELECT data from the workstation you are running the migration tool, I have seen a scenario where User will be able to see the tables, since catalog tables are accessible, but can’t read data from tables