Simple way to implement SQL Server to Mysql _mysql

This conversion needs to be dependent on the use of tools Navicat Premium.

First, to move the database to local SQL Server, I tried to go directly to local MySQL on other SQL Server servers on the local area network, as if there was a problem, and wanted to restore the remote database backup to local.

1. Open Navicat Premium, create a new database with the same name, and click the Import Wizard on the table. and select "ODBC".

　　

2. Select SQL Server provider and enter parameters.

　　

　　

　　

3, and then desperately next, next.

　　

　　

　　

Here is a conditional query, if you have too many unwanted data, or if there is a problem with the field type, you can set the import error here.

　　

Finished, eat out of work.

Add: This thing to SQL Server to MySQL data type conversion support is not very good, to manually set. But there is no problem importing data, the best way is:

Use tools First: Mss2sql converts SQL Server tables into MySQL tables, and then uses ODBC data for this tool.