[Reprint] how to import data from the MySQL database to the MSSql database [mysq_MySQL

[Reprint] how to import the data of Mysql5.5 database into MSSql database [mysql-connector-odbc-3.51.28-win32] original address: http://www.start4e.cn/tabid/62/forumid/-1/postid/57/scope/posts/Default.aspx

1, install mysql database ODBC driver, mysql-connector-odbc-3.51.19-win64.msi, http://www.mysql.com/find the corresponding windows under the mysql-connector-odbcdownload compressed package.


2. open the Control Panel, administrative tools, and data source ODBC, and add a MySQL ODBC 3.51 data source to the user DSN.



3. on the login tab, enter the Data Source Name. here, enter MysqlDNS (you can also Name the Data Source by yourself, as long as you select the correct Data Source Name when importing Data ); enter the Server, User, and Password. enter the correct Password and select the database to be imported. Set the port and Character Set used by MySql in connect options as needed.

Note: the character set must correspond to the Mysql Server. if Mysql uses the gbk character set, set the character set to gbk. Otherwise, the question mark may be garbled during import to SQL Server.

4. open the SQL server Enterprise Manager and create a new database named by myself. I will name it MySql. Right-click the database and select all tasks/import data.




5. select the data source as the mySQL data source just installed:





6. if the following error occurs because the SQL statement in MSSQL may be incompatible with Mysql, check the query statement and enter the correct SQL statement.

Www.start4e.cn