Migrating MySQL Databases to SQL Azure using SSMA–Part 3

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 !!!


Author: Arunraj

I am a Microsoft Certified Technology Specialist (Database Developer). I work on SQL Server programming since SQL Server 7.0 specializes in SQL Server Programming and Performance Tuning and has 14 years of hands-on experience. I hold a Master Degree in Computer Applications. I am also part of NJSQL User Group and Northern New Jersey .Net User Group.

2 thoughts on “Migrating MySQL Databases to SQL Azure using SSMA–Part 3”

  1. 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?


    1. Hi Kevin,

      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



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: