Use the mss2sql tool to convert SqlServer to Mysql full records, mss2sqlmysql

Use the mss2sql tool to convert SqlServer to Mysql full records, mss2sqlmysql

Today, I want to use ruby on rails to build a small project. I need to use the mysql database. The data in the project already exists, but is saved in SQL Server. I can use rails to operate SQL Server, however, I don't always feel very well matched. I want to use it after conversion. There are many conversion methods on the Internet. I wrote SQL code through ODBC and PHP programs, I think it is better to use tools for conversion. First, I tried to use ODBC and found that SQL Server's export function does not support mysql ODBC very well.

ODBC is divided into 32-bit and 64-bit. It starts with 32-bit. It cannot be displayed on Win7 64-bit. You can choose to add it only after downloading the 64-bit version from the mysql official website.

32-bit version:

Http://www.bkjia.com/database/142740.html

64-bit version:

Http://www.mysql.com/downloads/connector/odbc/

After clicking finish, you need to select your mysql database Source

In this way, you can see it in ODBC.

Unfortunately, the data exported from SQL server cannot be converted, and the architecture does not match.

No way, continue searching on the Internet and find a blog saying that mss2sql can be used for conversion. The result is successfully converted on win7 64-bit:

Mss2sql: http://www.bkjia.com/softs/209207.html

Open the compressed package after the download

Run mss2sql

The default value is Move to MysQL server directly. Select next.

Continue to the next step. Wait a moment.

This time, I need to connect to the MySQL server. I am Local, so I chose Local and enter your username and password.

Continue waiting for connection

Select the database to be converted in MS SQL

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 Overwrite the existing table Skip existing tables: Skip the existing table Merge: Merge

I only have an empty database in mysql, so I chose the first item, covering the whole.

Select the table to be converted and Add it to the conversion list. I need all the tables, so I chose Add all

Then there is a period of waiting.

There is not much data in this table, and it takes a little longer, about 10 minutes. If the table is large, it may be faster to use a program for conversion. Thank you for your convenience.

The following figure shows the table after the conversion. The data in the table is OK and there is no problem with Chinese.

The operating environment for this article is:

Win7 64-bit, SQL server 2008 express, Mysql 3.23.49, apache 1.3.33,

The perfect way to convert sqlserver to mysql. I use mss2sql to convert the result. The primary key is not auto-incrementing. But the key is the relationship between tables.

1. Although keepalived is an extension of LVS, it can be run independently for high availability. The typical use case is: keepalived + nginx
2. The combination of keepalived and nginx is common. It is rare with apache and does not support internal parameters. However, if LVS is installed, the second step can be done.
3. Yes. The number of items on the Internet is more suitable for specific scenarios. It is recommended that you read the official website and summarize them as follows:
Reference: www.keepalived.org/, www.keepalived.org/LVS-NAT-Keepalived-HOWTO.html

It is best to use navicat for mysql 8 to convert the database in SQL server 2005 to mysql.

Right-click the database to be exported in sqlserver2005