How to use SQL Server Migration Assistant for MySQL

The SQL Server Migration Assistant (SSMA) team today announced the launch of the MySQL Migration Assistant Microsoft SQL Server Migration Assistant 2008 for MySQL.

Read the relevant information: Microsoft released the SQL Server migration assistant for MySQL

Download SSMA for MySQL: SQL Server migration assistant for MySQL 1.0

In fact, Microsoft 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.

Download the Help file of the tool contained in the file. Next I will use SSMA to import a MySQL WordPress database to SQL Server.

Note: I only use WordPress as an example to demonstrate how to migrate a database. If you really want to run WordPress in SQL Server, refer to WordPress's Microsoft

1. Download SQL Server migration assistant

After the installation is complete, double-click the shortcut on your desktop to start the application:

Note that you have installed the MySQL client when installing SSMA. If not, the assistant will prompt you to download the ODBC connector of MySQL.

2. Get a registration code

When you use SSMA for the first time, you need to obtain a registration code from Microsoft's official website, file name ?? For mysql-ssma.license, download and save it in a folder on the hard disk:

3. Create a new project

After the program is started, click the new project icon in the upper left corner:

Then select whether you want to migrate to SQL Server or SQL Azure (select SQL Server ):

4. Connect to MySQL

Click the connect to MySQL icon in the upper left corner (you must confirm that the ODBC connector for MySQL is installed). Then, your MySQL database information will be displayed in the Tree View.

5. Create a mode Migration Report

Select the database to be migrated, right-click the database name, and select create report:

The generated report shows you any problems that may occur during architecture migration. If there is a problem, you can solve the problem by changing some default mode ing settings (edit the information on the tab, as mentioned in step 1.

6. Connect to SQL Server (or SQL Azure, depending on your choice in step 1)

Click "connect to SQL Server" in the upper left corner. You can provide creden。 to connect to SQL Server or SQL Azure. If the MySQL database you selected in Step 4 has the same name and does not exist, you will be asked if you want to create one.

Note: If you do not want SSMA to create a database for you, you should specify the database to be migrated in the connection dialog box. By default, SSMA must be created synchronously before converting all objects in MySQL database DB1 to db1 ). The simplest way to do this is to specify the database name in the SQL Server connection dialog box when establishing a connection to the SQL Server database.

Now you can see the tree view of SQL Server Data in SQL Server resource manager. Select the Migration Mode.

7. In the metadata Resource Manager of MySQL, right-click the database to be migrated and select "Conversion Mode ":

At this point, you may need to make some changes in the conversion mode. For example, I have selected the link_updated column, which is a column that can be empty, because MySQL has set the default value, 0000-00-00 00:00:00 is a special value and will be considered as a null value for data migration. If the data is not changed during migration, this change may cause errors.

8. SQL Server Database Synchronization

In SQL Server, select the database to be synchronized, right-click and select synchronize with database

In the "synchronize with Database" dialog box that appears, click "OK ".

9. migrate data

In MySQL metadata Resource Manager, right-click the database to be migrated, select data migration, and enter the connection creden。 of the MySQL and SQL Server databases.

Now your database architecture and data are migrated.