How to migrate SQL Server data to MySQL

I. BACKGROUND

Because the database used at the beginning of the project is SQL Server, and then the stored database is adjusted to MySQL, SQL Server data needs to be transferred to MySQL; Because of the more tables involved, you want to generate the corresponding table in MySQL and import the data;

On the Internet to find some information, such as: Access and MSSQL into MySQL, MySQL migration implementation of MSSQL to MySQL data migration, although do not know if the practice can be successfully transferred, but inside the process is more complex, did not try, and later found a way , the most important thing is simplicity and accuracy (no obvious bugs are found at the moment), shared here.

Ii. Transfer of data

I use the MySQL client tool SQLyog, the installation of this tool is very simple. After the installation is completed click on the target database to be imported, click the right button "import"-> "import extenal Data";

(Figure1:import)

Select "Start a new job" and click "Next";

(Figure2:start a new job)

The following is the Setup interface for DSN, and if your list does not require you to export a DSN for the SQL Server database, you need to create a new DSN to connect to the SQL Sever with the "Create a new DSN";

(Figure3:create a New DSN)

(Figure4: Create a new data source)

(FIGURE5: Select data Source Type)