SQL Server convert MySQL

SQL Server data into MySQL data, can be said to be a cliché, there are many ways online, today we look at a different method, but also very simple, although a little flaw, but it is a good way, of course, if the combination of mss2sql that is very perfect

This conversion relies on the use of tools Navicat Premium.

First, move the database to local SQL Server, and I tried to go to local MySQL on other SQL Servers directly on the LAN. There seems to be a problem trying to restore the remote database backup locally.

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

　　

2. Select the SQL Server provider and enter the parameters.

　　

　　

　　

3, then just desperately next, next.

　　

　　

　　

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

　　

It's done, dinner's off.

Add: This thing is not very good for SQL Server to MySQL data type conversion, to be set manually. But the best way to import data without problems is:

First, use the tool: Mss2sql convert SQL Server tables to MySQL tables, and then use the ODBC Guidance data for this tool.

SQL Server convert MySQL