SqlServer to Mysql, sqlserver to mysql
After successfully installing MySQL yesterday, I am preparing to change the SQL SERVER database in the original project to the MYSQL database. If you need to manually write a large amount of table structures and table data, then ......
Then there are various Baidu, Google, and Q & A pioneers. The answers are varied, but they are confused.
Some say that you can directly use the SQL SERVER built-in import and export, but the experiment has never been successful. (If there is a success, please let me know !)
Try one
Note: To use the preceding method, you must first install the odbc driver of mysql. During installation, both the 64-bit and 32-bit must be installed once. Otherwise, an error will be reported. (This is my case)
Odbc installation Tutorial: https://jingyan.baidu.com/article/8065f87f38b31423312498e4.html
Test 2
Later I heard that Navicat Premium may directly synchronize the table structure and data of SQL server to MYSQL. Next I tried again and finally I had to end with a failure!
Try 3
After several twists and turns, I found a good thing, mss2sql, and started a new round of trials with a try attitude.
Mss2sql: http://files.cnblogs.com/andrew-blog/mss2sql.rar
Run mss2sql
Click Next. If there is a database with the same name in mysql, you will be asked to select the conversion method, which is
- Overwrite the entire database: Overwrite the entire database
- Overwrite existing tables only: only existing tables are overwritten.
- Skip existing tables: Skips existing tables
- Merge: Merge
It takes a long time to import a table and you need to wait patiently.
After the operation is successful, you can see that the table structure and data are synchronized from the MYSQL database.
The above Article reference: http://www.cnblogs.com/angestudy/archive/2012/06/04/2533548.html thanks to the author (seeking happy) selfless sharing
So far, the data table and Data Synchronization have been completed successfully! After synchronization, whether there will be other things that are not correct has not been verified one by one, but the help of this tool does save a lot of time and manpower.
Although SQL SERVER has been able to synchronize data tables and data from MYSQL to MYSQL, the younger brother is still curious about the above two methods: One and Two, hope to mention something!
Data tables and data are in place. Next, we need to rebuild the database connection of the original project.
The road is long, and I will go up and down to find the cable (abuse )!