MySQL to MSSQL Migration Tool--ssma

The SQL Server Migration Assistant (SSMA) team developed the Migration Assistant for MySQL to Microsoft SQL Server Migration Assistant for MySQL. Microsoft has also released three other migration assistants: SSMA for Access, SSMA for Oracle, and SSMA for Sybase (all v4.2). It can also migrate a MySQL database to the cloud of SQL Azure.

01. Installation

Before installing Ssma, be sure to install MySQL and MSSQL ODBC, of course, you can also directly install the two clients, install the client, will automatically install ODBC.

If you install ODBC before installing it, it will remind you to download the installation, if you install ODBC, open Ssma also reported error "Missing ODBC", probably because the operating system is 64-bit, you open the 32-bit application, you need to open 64-bit.

02. Connect

Connection is very simple, connect MySQL and MSSQL, connection settings is simple, connect well, you can see the existing database.

03. Use

This interface is simple, a row of buttons on the toolbar is the function to use: new scenario-Connect mysql-Connection mssql-Create report-Transform fabric-(Synchronize database)-copy data.

Create a report : It is the function of checking the database, including the structure and data of the database, and generating reports, and if there is a problem there will be an error prompt or warning. The right-click menu is also a common feature.

This is the report that was created.

Conversion Structure : If there is no big problem, you can click on the conversion structure (CTRL+R), the converted log will appear in the input window, the result of the conversion in the Ssma SQL window (now the result of the conversion database is not yet into the MSSQL)

synchronizing the database : Right-click on the newly generated database in the Ssma SQL window, which is the synchronization database.

copy data : Next, right-click on the Myssql database to copy the data, which requires the MySQL database password to be entered again. The following copies the data after the report.

Inspection Results : Not only to see the results of the report, but also to check the data, the data for inspection.

04. Questions

Here are some common questions:

(1) Data type correspondence problem. Two databases incompatible, during the conversion process, we are the most concerned about the data correspondence, you can set up in the scenario. In practice, what I'm encountering is that longtext to the nvarchar (max) type, with a large amount of data (700,000 lengths for a field), can also be stored.

(2) Do not know which step to set the problem, each table will appear a Ssma identification field, if necessary, delete it.

05. Summary

In general, this database migration tool is very useful and can be used for actual production.

MySQL to MSSQL Migration Tool--ssma