How to convert mysql from sqlserver: 1. Move the database to the local SQLServer; 2. Create a new database with the same name; 3. Select the SQLServer provider and enter the parameters; 4. Import the data.
The operating environment of this article: Windows 7 system, Navicat Premium version 15, Dell G3 computer.
How to convert SQLServer to MYSQL (data connection)
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.
it's here There is a conditional query. If there is too much unwanted data, or there is a problem with the field type that causes an import error, you can set it here.
Finished, let’s have dinner after get off work.
Supplement: This thing does not support SQLServer to MySQL data type conversion very well and 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 this tool ODBC import data.
2014-11-26
Problem record:
1. When SQLServer data is imported into MySQL, mss2sql does not handle bit types well. , so the length of the field table with bit type must be changed to 8 after importing, otherwise subsequent import operations will fail.
2. When importing data, if it is a LAN database, the type to be selected is:
The SQL statement of SQLServer is the SQL statement of MySQL:
1. Insert auto-increment column to Null (if it is abbreviated and do not write the column name);
2. Paging should generally be changed to MySQL's Limit;
3. Table name is not required Prefixes such as dbo. appear;
Recommended learning: "mysql video tutorial"
The above is the detailed content of How to convert sqlserver to mysql. For more information, please follow other related articles on the PHP Chinese website!