Convert SQL Server to MySQL using Mss2sql

Because the project needs to need so in the Web site, and now summed up a bit, I hope to help you, use the software has mss2sql, before using the software, please install SQLService and MySQL in the local first.

Mss2sql:http://files.cnblogs.com/andrew-blog/mss2sql.rar

Reference: http://www.cnblogs.com/andrew-blog/archive/2011/12/03/SQL_mss2sql.html

To open a compressed package after download

Run Mss2sql

The default is move to MysQL server directly, select Next

Go on, wait a minute.

This time it is necessary to connect to MySQL server, I am local, so choose Local, fill in your username and password

Continue waiting for connection

Select the database that needs to be converted in MS SQL

Click Next, if MySQL has the same name database, will let you choose the way to convert, respectively is

• Overwrite the entire database: covering the entire data base
• Overwrite existing tables only: Overwrite the existing table
• Skip existing tables: Skipping tables that exist
• Merge: Merging

My MySQL is just an empty database, so I chose the first item, the whole coverage.

Select the table to be converted, add to the conversion list, I need all the tables, so I chose the add all

Then there's a time to wait

There is not much data in this table, it takes a little longer, about 10 minutes, if the table is large, it may be faster to use the program to convert, there is a convenient way also please tell me

The following is the successful conversion of the table, the data inside the OK, Chinese is no problem.

Convert SQL Server to MySQL using Mss2sql