Convert MySQL to MMSQLServer2008 instance procedure

For project reasons, the MySQL database needs to be converted to MMSQL2008. Read the online tutorial, downloaded a lot of software to try, and finally converted to success. Write an article to help someone with the need.

1, first have to have a MMSQL2008 database, and MySQL database.

2. Then download the official Microsoft Conversion software: Microsoft SQL Server Migration Assistant for MySQL, note here that the new version is 2012 cannot convert 2008.

3, and then download the MySQL ODBC driver installation, here my current system is 64-bit WIN8, thought that only need to follow the 64-bit can, but the fact that the next steps are not going to go on, and later also installed 32-bit on the can.

4, configure MySQL ODBC, go to the Control Panel to find the data source (1) such as:,

Then configure the 32-bit and 64-mysqlodbc data sources separately, such as:

5. Download the conversion software from Microsoft SQL Server migration Assistant for MySQL key, which can be seen as shown in the Open software:

6, the above all normal after you can open the software, after entering the software is very simple, a little bit of software to understand the person a look will, connect MySQL, sqlserver2008

7. Key steps come, start conversion:

8. After the conversion is complete, open your mmsql2008 login to see the converted database. If you do not see the switch server name look, I did not notice, converted several times and then open did not see, suddenly thought is not the server name opened with the conversion is not one, and then switch to find as expected.

Convert MySQL to MMSQLServer2008 instance procedure