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

This article mainly introduces "the actual operation mode of MSSQL to MySQL database". In the daily operation, I believe that many people have doubts about the actual operation mode of MSSQL to MySQL database. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "the actual operation mode of MSSQL to MySQL database". Next, please follow the editor to study!

Today, I convert a MSSQL database to MySQL. In the absence of a conversion tool, I use the following manual conversion methods for tables with few fields, which is quite convenient. MSSQL uses enterprise manager operations, and MySQL uses phpmyadmin operations.

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, while I use the MYISAM type, gbk encoding, and 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-p

The above related content is the introduction of some records from MSSQL to MySQL database. I hope you can get something.

At this point, the study of "the actual operation of MSSQL to MySQL database" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.