SQL Server Data Import Mysql course details

Source: Internet
Author: User
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
  • Navicat for MySQL version 10.0.9

Method/step
  1. 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. 2

    Click "table" in the website of the created target database. The import wizard option is displayed on the right.

  3. 3

    Select the SQL Server database ODBC, "Next", Data Link Attribute-SQL SERVER ODBC

  4. 4

    Create an access SQL SERVER ODBC.

  5. 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. 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. 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.

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.