Shulou(Shulou.com)05/31 Report--

Editor to share with you how to convert sql server into mysql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Sqlserver transform mysql method: 1, move the database to the local SQLServer;2, create a new database with the same name; 3, select SQLServer provider, and enter parameters; 4, import data.

This article operating environment: Windows7 system, Navicat Premium version 15, Dell G3 computer.

This conversion depends on the use of the tool Navicat Premium.

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

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 go all out for the next step, the next step.

There is a conditional query here, which can be set here if there is too much unwanted data, or if there is a problem with the field type that leads to an import error.

It's done. Eat after work.

Add: this thing's support for SQLServer to MySQL data type conversion is not very good, it should be set manually. But there is no problem with importing data, and the best way is to:

First use the tool: mss2sql converts the SQLServer table into the MYSQL table, and then import the data in ODBC using this tool.

2014-11-26

Problem record:

1. When SQLServer data is imported into MySQL, mss2sql does not handle the bit type very well, so the length of the field table with bit type should be changed to 8 after import, otherwise subsequent import operations will fail.

2. When importing data, if it is a local area network database, the type to be selected is:

SQLServer's SQL statement is specific to MySQL's SQL statement:

1. Insert add column to Null (if it is abbreviated without column name)

2. Generally speaking, the paging should be changed to the Limit of MySQL

3. The table name should not appear dbo. Equal prefix

The above is all the content of the article "how to convert sql server to mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.