Simple SQL Server to MYSQL

This conversion depends on the NavicatPremium tool. First, move the database to the local SQL Server. I tried to directly transfer the database to another SQL server on the LAN. It seems that there is a problem, and I want to restore the remote database to the local backup. 1. Open NavicatPremium, create a database with the same name, and click "Export" on the table.

This conversion depends on the Navicat Premium tool. First, move the database to the local SQL Server. I tried to directly transfer the database to another SQL server on the LAN. It seems that there is a problem, and I want to restore the remote database to the local backup. 1. Open Navicat Premium, create a database with the same name, and click "Export" on the table.

This conversion depends on the Navicat Premium tool.

First, move the database to the local SQL Server. I tried to directly transfer the database to another SQL server on the LAN. It seems that there is a problem, and I want to restore the remote database to the local backup.

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

2. Select the SQLServer provider and enter parameters.

3. Then, I tried my best to take the next step.

Here is a conditional query. If there are too many unwanted data or the field type is incorrect, you can set it here.

It's a success. You have to eat after work.

Supplement: This feature does not support data type conversion from SQLServer to MySQL. You need to set it manually. But there is no problem with importing data. The best way is:

First use the tool: mss2sql to convert SQLServer tables to MYSQL tables, and then use this tool to export data through ODBC.