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

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

image

Click “Next” to proceed

image

Accept the license agreement and click “Next” to proceed

image

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

image

Select “Setup Type” and click Next to Proceed

image

image

Click “Install” to confirm and proceed with installation

image

image

Click “Finish” to complete the installation

image

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

image

Accept the license agreement and Click “Next” to proceed

image

Select Setup type and click “Next” to proceed

image

image

Click “Install” to confirm and proceed with installation

image

image

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

image

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

image

Specify Authentication information and click “Next” to proceed

image

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

image

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

image

Once installed the following message will be displayed

image

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

image

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.

Advertisements

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: