Import MySQL data to SqlServer 1. install ODBC driver for mysql database, mysql-connector-odbc-3.51.19-win32.msi
2. open the control panel management tool data source ODBC and add a MySQL ODBC 3.51 data source to the user DSN.
3. on the log in login tab, enter the Data Source Name. here, enter MysqlDNS. Then, enter the Server, User, and Password. enter the correct Password and select the database to import. 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 MySql database. Right-click the database and select all tasks to import data.
5. select another data source (ODBC data source), and the user/system DSN is MysqlDNS. Other data can be imported from the MySql database to the MSSQL database according to the Wizard.