Shulou(Shulou.com)06/01 Report--

The SQL Server Migration Assistant (SSMA) team developed a migration assistant for MySQL, Microsoft SQL Server Migration Assistant 2008 for MySQL. Microsoft also released three other migration assistants: SSMA for Access, SSMA for Oracle, and 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 ODBC of mysql and mssql. Of course, you can also install the client of both directly. When you install the client, ODBC will be installed automatically.

If you do not install ODBC before installation, it will remind you to download the installation; if you installed ODBC, open SSMA and report "missing ODBC", probably because the operating system is 64-bit, you open a 32-bit application, you need to open 64-bit.

02. Connect

The connection is very simple, connect mysql and mssql, the connection setting is simple, after the connection, you can see the existing database.

03. Use

The interface is simple, and a row of buttons on the toolbar is what you want to use: create a new solution-connect mysql- to mssql- to create a report-transform structure-(synchronize database)-copy data.

Create a report: it is used to check the database, including the structure and data of the database, and generate a report that will give an error prompt or warning if there is a problem. The right-click menu in the following figure is also a common function.

This is the report created.

Conversion structure: if there is no big problem, you can click on the conversion structure (Ctrl+R), the conversion log will appear in the input window, and the conversion result will be in the SQL window of SSMA (the conversion result database has not yet been entered into Mssql).

Synchronized database: right-click on the newly generated database in SSMA's SQL window, and there is a synchronized database.

Copy data: next, right-click on the myssql database to copy the data, which requires re-entering the mysql database password. The following report after copying the data.

Check results: not only to see the report of the conversion results, but also to spot-check the data and check the data.

04. problem

Here are some common questions:

(1) the corresponding problem of data type. The two databases are not compatible. In the conversion process, what we are most concerned about is the data correspondence, which you can set in the solution. In practice, what I encounter is that longtext has been converted to nvarchar (max), which can also be stored if there is a large amount of data (a field has 700000 lengths).

(2) do not know which step to set the problem, each table will appear a SSMA identity field, if necessary, delete it.

05. Summary

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.