SQL Server database migration to MySQL

Source: Internet
Author: User
Tags dsn

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.