Home > SQL Azure, SQL Azure Migration > Migrating MySQL Databases to SQL Azure using SSMA–Part 3

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”

image

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

image

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”

image

Specify the password for the target server and click “Connect”

image

The schema migration preview window will display the list of objects being migrated, Click “Ok” to proceed

image

Migration process will be displayed in Output window, Once complete the output window will display the below message

image

Now we have successfully migrated the schema, To migrate the data, right click on Source Database and click “Migrate Data”

image

Specify the MySQL Server credentials and click “Connect”

image

Specify SQL Azure Target server credentials and click “Connect” to proceed

image

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.

image

image

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

image

Now we have successfully migrated the database schema and data from MySQL database to SQL Azure

Hope you all find this information useful !!!

Advertisements
  1. Kevin
    October 19, 2011 at 4:46 pm

    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?

    • October 19, 2011 at 5:34 pm

      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

      Regards
      Arunraj

  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: