How to import MySQL data into SQL Server

1. Install MySQL database ODBC driver, Mysql-connector-odbc-3.51.19-win32.msi

2. Open the Control Panel \ Admin tool \ Data source ODBC and add a MySQL ODBC 3.51 data source to the user DSN.

3. Enter the data source name in the Login Login tab, enter MYSQLDNS in the server server, user username, password password, and then select the database you want to import after you enter it correctly. Set the port and character set character for MySQL to use in the Connect Options connect option.

Note: The character set must correspond to the MySQL server, if MySQL uses the GBK character set, you must set the character set to GBK, otherwise the import to SQL Server may appear the question mark garbled.

4. Open SQL Server Enterprise Manager to create a new database MySQL. Select the database and right-click to select All Tasks \ Import data.

5. Select the data source as another (ODBC data source), and the user/System DSN is Mysqldns. The rest is based on the wizard to import data from the MySQL database into the MSSQL database.