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

This article focuses on "how to achieve MSSQL to MYSQL", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to convert MSSQL to MYSQL.

1. With MSSQL enterprise manager, open the structure of the table (design table), locally use phpmyadmin to create one by one according to the structure, at the same time optimize the table data fields, the table creation is completed.

two。 Use enterprise manager to export single table, import source selection text, delimiter selection;, originally',', because phpmyadmin default is;, so choose;. Export a text file.

3. Using the phpmyadmin single table import function, select the following CSV to use LOAD DATA, and you can import the table contents.

Done!

If there are many fields, or many records, then this method is not applicable, you need to use software to help. Currently, as far as enjoy knows, there are two good software that can convert MSSQL into MYSQL. One is DBConvert for MSSQL & MySQL, which can be converted in both directions, more than ten meters. One is MSSQL to MySQL, which is very small, and the compressed package is only more than 1m. It can specify which tables of a library can be imported into sql or directly into MYSQL, which is very useful.

I used MSSQL to MySQL to save a MSSQL library to sql, and found the following two problems in practice.

1. Table creation problem. The generated table sql specifies ENGINE=INNODB, and I use the MYISAM type, gbk encoding, so change it to: ENGINE=MYISAM DEFAULT CHARSET = GBK

two。 Coding problem. My database is gbk coded, and I added the option-- default-character-set=gbk when importing it, so that the Chinese language can be displayed normally.

Mysql-- default-character-set=gbk-D DBNAME < E:\ hx\ 9enjoy.txt-uroot.

At this point, I believe you have a deeper understanding of "how to achieve MSSQL to MYSQL". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.