Convert SQL Server to Mysql full records using the Mss2sql tool _mysql

Today I want to use Ruby on Rails to do a small project, need to use the MySQL database, the project's data has been, but is stored in SQL Server, with rails can operate SQL Server, but the total feeling does not match, want to convert to use, the internet turned down, There are many ways to convert, through ODBC, through the PHP program, write the SQL code, think the conversion or use tools, first try to play with ODBC, and found that SQL Server's export capabilities for MySQL ODBC support is not too good

ODBC 32, 64 bit, the beginning of a 32-bit, in the Win7 64-bit above display, and from the MySQL website to download a 64-bit version can choose to add

32-bit version:

Http://www.jb51.net/database/142740.html

64-bit version:

http://www.mysql.com/downloads/connector/odbc/

When clicked, you need to choose your MySQL database source

So you can see it in ODBC.

Unfortunately, the conversion was unsuccessful in SQL Server's exported data and said that the architecture did not match.

No way, continue to search on the internet, found a blog that can use Mss2sql to convert, the result of the conversion on the Win7 64-bit success:

Mss2sql Download Address: http://www.jb51.net/softs/209207.html

To open a compressed package after downloading

Run Mss2sql

The default is move to MysQL server directly, select Next

Go to the next step and wait a moment

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

Continue waiting for connection

Select a database to convert in MS SQL

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

Overwrite the entire database: Overwrite the entire DB Overwrite existing tables only: Overwrite existing table skip existing tables: Skip existing table Merge: Merge

My MySQL inside is just an empty database, so I chose the first item, the entire overlay.

Select the table you want to convert, add it to the conversion list, I need all of the tables, so I chose add all

And then it's just a moment of waiting.

The data in this table is not much, spend a little longer, about 10 minutes, if the table is big, may use the procedure to convert will be quicker, has the convenient method also please sue for thanks

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

The operating environment of this article is:

Win7 64 bits, SQL Server 2008 Express, Mysql 3.23.49,apache 1.3.33,