MySQL import of external SQL Server data

in the previous blog "MySQL 5.6.22 installation Tutorial", we introduced the installation of MySQL. Today we'll focus on how to import external SQL Server data in MySQL, in short, how we can migrate data from a SQL Server database to a MySQL database.

in order to achieve the data migration we want, we first need to download a gadget SQLyog and then install it on our computer, and then we'll start our data migration step-by-step with this gadget:

First look at the table structure in our SQL Server database and the data in the table

Open SQLyog, set the data connection:

                                           

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

The preparation is ready, so let's start by importing the 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 a user DSN or a file DSN, click Create a new DSN

Create a data source

Select SQL Server

Set Save path

Complete

To create a SQL Server data source

Enter your login ID and password

Change the default database

Complete

Test data source

Select File DSN

Select the database you want to import in MySQL

Next

Select the table and target table to import

Next

Next

Import succeeded

And finally, look at the tables in our MySQL database.

With the above steps we can successfully import the data from SQL Server into MySQL, although it is a bit cumbersome, but it is really simple!

MySQL import of external SQL Server data