Step by Step Tutorial to Convert MSSQL to MySQL
using Data Loader

In this tour we will be giving an example on how to convert databases from MS SQL Server to MySQL using Data Loader.

Data Loader will automatically

• Converts MSSQL Schemas and Tables to MySQL Schemas and Tables with matching datatypes
• Copy rows from MSSQL to MySQL tables
• Import Constraints and relationships
• Imports Indexes
• Imports Identity columns
• Imports Auto Increment Columns
• Imports Default values

Step 1:-

If you want to practice this on your machine then we recommend you to download the free Trial Edition of Data Loader now in case you have not done it already.

We will migrate Microsoft Sample Northwind Database which is supplied by Microsoft for practicing. If you don't have it, you can download it from by visiting this Website and click here to know the instructions on how to install these sample databases in MS SQL Server

First of all lets create a blank database in MySQL. This will be our target database. To do this first start the MySQL Command Line utility

Then you will get the screen as shown below and you will prompted for password. Type your root password and press enter

Then at the MySQL prompt type the following command to create the blank database.

mysql> Create database NorthWind;

After creating the target MySQL database. Now start Data Loader Utility.

 Related: Top 3 Tools for converting MSSQL to MySQL

Next Step >