Detailed explanation of the method of converting SQLServer to MYSQL

Converting

SqlServer data into mysql data can be said to be a cliché. There are many methods on the Internet. Today we will look at a different method, and it is also very simple. Simple, although it has some minor flaws, it is still a good method. Of course, it would be perfect if combined with mss2sql.

This conversion requires the use of the tool Navicat Premium.​

First, move the database to the local SQLServer. I have tried directly transferring to the local Mysql on other SQLServer servers on the LAN. There seems to be a problem. I want to restore the remote database backup to the local.

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

　

　2. Select the SQLServer provider and enter the parameters.

　

　

　

　3. Then take the next step, the next step.

　

　

　

　There is a condition here query, if there are too many Unwanted data, or problems with field types that cause import errors can be set here.

　

　It’s done, let’s have dinner after get off work.

Supplement: This thing does not support the conversion of SQLServer to MySQL data type very well, so it needs to be set manually. But there is no problem in importing data. The best way is:

First use the tool: mss2sql to convert the SQLServer table into a MYSQL table, and then use the ODBC of this tool to import the data.

The above is the detailed content of Detailed explanation of the method of converting SQLServer to MYSQL. For more information, please follow other related articles on the PHP Chinese website!