Migrating MySQL Databases to SQL Azure using SSMA–Part 1

Microsoft SQL Server Migration Assistant (SSMA) for MySQL is a tool to automate migration from MySQL database to SQL Server or SQL Azure.

SSMA for MySQL v 5.0 is freely available from Microsoft, you can download it from the following link http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ac017a90-3b53-49b6-92a7-0f91623ef530

It also has free support. SSMA automates the migration process by doing schema analysis, preparing migration report and migrating data.

SSMA for MySQL v 5.0 supports migration from MySQL 4.1 and higher to SQL Server 2005 / 2008 / 2008 R2 and SQL Azure

To install and run this we need MySQL ODBC Connection v 5.1, which you can download from the following link http://www.mysql.com/downloads/connector/odbc/

Let us see how to install the SSMA for MySQL v 5.0

Once downloaded the setup from the above URL, extract the zip file and run “SSMA for MySQL 5.0”

Click “Next” to proceed

Accept the license agreement and click “Next” to proceed

Select Usage Report Settings, if you wish to report and then click “Next” to proceed

Select “Setup Type” and click Next to Proceed

Click “Install” to confirm and proceed with installation

Click “Finish” to complete the installation

Now we have successfully installed SSMA for MySQL v5.0.

In addition to this, we need to install SSMA for MySQL Extension Pack as well

Run the “SSMA for MySQL 5.0 Extension Pack.exe” and click “Next” to proceed

Accept the license agreement and Click “Next” to proceed

Select Setup type and click “Next” to proceed

Click “Install” to confirm and proceed with installation

Click “Next” to complete the installtion, and to start the configuration process of Utility database

Select the SQL Server instance on which you want to install the Utility database and click “Next” to proceed

Specify Authentication information and click “Next” to proceed

Provide a strong password to protect the authentication information stored in Utility database and click “Next” to proceed

Select “Install Utilities…” option and click “Next” to finish the installation

Once installed the following message will be displayed

If you want to install Utility database in another server, click “Yes” or click “No” to finish the installation

Click “Exit” to complete the installation.

Now we have successfully installed and configured the SSMA extension pack for MySQL.

In the next post we will see how to create a new migration project, analyze the MySQL database schema, prepare migration report and migrate data.