SQL Server Data import MySQL detailed tutorial

SQL Server Data import MySQL detailed tutorial

Both the SQL Server database and the Mysql database are relational databases, and although many databases have been re-developed and extended to SQL statements, the methods or usages that are executed in different databases are inconsistent, but SQL Server,mysql, Access is used in the SQL language standard, and data from different databases can be imported. The import of big data is quite significant.

Today, I share with you, I use the convenient "SQL Server data import method in MySQL ", I hope to give you the project development "SQL Server database and MySQL database data import and Export " bring help.

Tools/Materials

• Navicat for MySQL version 10.0.9

Method/Step

2. 1

   In Navicat for MySQL Manager, create the target database

   (Note: Because it is a point-to-point data import, the name of the database to be exported in SQL Server is the same as the name of the database to be imported into MySQL)

4. 2

   Click the "Table" item in the website point of the created target database and the Import Wizard option will appear on the right.

6. 3

   Select SQL Server database ODBC, "next", Data Link Properties-sql SERVER ODBC

8. 4

   Create access to SQL SERVER ODBC.

10. 5

    Back in the Import Wizard, you have been able to view all the tables in the SQL Server source database and select the tables you want to import.

12. 6

    Click Next to see if the data properties of the fields in each table are correct, and if there is a problem you can make adjustments (some fields in SQL Server use the same, but the names are different, note the changes, or the import fails)

14. 7

    Select "Add"-"Next"-"Start import" and you can

    END

Precautions

• Because it is a point-to-point data import, the name of the database to be exported in SQL Server is the same as the name of the database to be imported into MySQL

• Some fields in SQL Server use the same, but the names are different, note the changes, or the import fails