Import External SQL Server data from MySQL, mysqlsql

Import External SQL Server data from MySQL, mysqlsql

In the previous blog "MySQL 5.6.22 installation tutorial", we introduced MySQL installation. Today, we will mainly explain how to import External SQL Server data in MySQL. In short, it is how to migrate the data in the SQL Server database to the MySQL database.

To achieve the desired data migration, we first need to download a small tool SQLyog and install it on our computer. Next we will start our data migration step by step using this tool:

First, let's take a look at the table structure and data in the SQL Server database.

Open SQLyog and set the data connection:

Create a table with the same table structure as that in the SQL Server database

After the preparation is complete, let's start importing data step by step.

Open the import external data wizard

 

Start a new job

You need to create an ODBC Data Link here. You can use the user DSN or file DSN, and click Create a new DSN.

Create a data source

Select SQL Server

Set save path

Complete

Create an SQL Server Data Source

Enter the logon ID and Password

Change default database

Complete

Test Data Source

Select File DSN

Select the database to be imported from MySQL

Next step

Select the table to be imported and the target table

Next step

Next step

Imported

Finally, let's look at the tables in our MySQL database.

Through the above steps, we can successfully import data from SQL Server to MySQL. Although it is a little complicated, it is actually very simple!