MySQL Import SQL Server database table

Original: https://zhidao.baidu.com/question/1114325744502691499.html

In Navicat for MySQL Manager, create the target database
(Note: Because it is a point-to-point data import, the name of the database to be exported in SQL Server is the same as the name of the database to be imported into MySQL)

Click the "Table" item in the website point of the created target database and the Import Wizard option will appear on the right.

Select SQL Server database ODBC, "next", Data Link Properties-sql SERVER ODBC

Create access to SQL SERVER ODBC.

Back in the Import Wizard, you have been able to view all the tables in the SQL Server source database and select the tables you want to import.

Click Next to see if the data properties of the fields in each table are correct, and if there is a problem you can make adjustments (some fields in SQL Server use the same, but the names are different, note the changes, or the import fails)

Select "Add"-"Next"-"Start import" and you can

MySQL Import SQL Server database table