SQL SERVER migration to MySQL
1. The first need to download a mediation software SQLyog. After the installation is complete, click on the target database to import, right click "Import", "Import external database";
2. Click to start a new task
3. Set the DSN, such as 1
4. Select File Data source options
5. Select a data source type of SQL Server
6. Save the above file as a suffix. dsn file (this is assumed to be ZX.DSN) Select a data source to save the path
7. Select the SQL Server server
8. Set the SQL Server account and password (change the default database to use ANSI-referenced identifiers), such as 2
9. Select the SQL Server database
10. Test the database Source
11. Select "File DSN", select the DSN we just created in the browse, then fill in the account number and password to log in to SQL Server;
12. Select the target MySQL server, fill in the IP address and account password, and need to select the target database
13. Copy a table or use a SQL script to filter the data;
14. Copy the table, which includes the SQL Server table field and the MySQL table field corresponding to the relationship between "Map", Advanced Option "" ", Filter" WHERE ".
15. Advanced Options Select "Meet Problem termination"
16. Select "Start Run" and the path to log file
17.log
Chart 1 Figure 2
Figure 2
Note: 1. Explanation of the intermediary software SQLyog and its installation link: SQLyog is a quick and concise tool for graphically managing MySQL databases, and it is able to manage your database effectively from any location. Link: https://pan.baidu.com/s/1NDs_ Valu3fzbgafxj30wuq Password: 9n3z
2. When setting up DSN, if the IP address of this machine is not available, you can select 127.0.0.1
SQL Server database migration to MySQL