SQL Server Data Import Mysql detailed tutorial SQL server data import Mysql detailed tutorial SQL Server database and Mysql database are relational databases, although many databases have re-developed and extended SQL statements, the methods or usage in different databases are different, but SQL Server, Mysql, and Access all use S.
SQL Server Data Import Mysql detailed tutorial SQL Server data import Mysql detailed tutorial SQL Server database and Mysql database are relational databases, although many databases have re-developed and expanded SQL statements, the methods or usage in different databases are different, but SQL Server, Mysql, and Access all use S.
SQL Server Data Import Mysql detailed tutorial
SQL Server Data Import Mysql detailed tutorial
Both the SQL Server database and Mysql database are relational databases. Although many databases redevelop and expand SQL statements, different methods or usages are executed in different databases, however, SQL Server, Mysql, and Access all adopt SQL language standards. Data in different databases can be imported. The import of big data is of great significance.
Today, I will share with you the convenient"How to import data from SQL server to mysql", Hope to give everyone the Project Development"Import and export data from the SQL server database and mysql database"To help.
Tools/Raw Materials
Method/step
- 1
In the Navicat for MySQL manager, create the target database
(Note: For point-to-point data import, the name of the database to be exported in SQL server must be the same as that of the database to be imported to Mysql)
- 2
Click "table" in the website of the created target database. The import wizard option is displayed on the right.
- 3
Select the SQL Server database ODBC, "Next", Data Link Attribute-SQL SERVER ODBC
- 4
Create an access SQL SERVER ODBC.
- 5
Return to the import wizard and find that you can view all the tables in the SQL Server Source database and select the tables to be imported.
- 6
Click Next to check whether the data attributes of fields in each table are correct. If any problem exists, adjust it. (Some fields in SQL server have the same purpose, but their names are different. Make sure to modify them, otherwise, the import will fail)
- 7
Select "add"-"Next"-"Start import,
END
Notes
For point-to-point data import, the name of the database to be exported in SQL server must be the same as that of the database to be imported to Mysql.
Some fields in SQL server use the same purpose but have different names. Make sure to modify them. Otherwise, the import will fail.