Tutorial to Convert MSSQL to MySQL

Data Loader Will Automatically

Convert MSSQL schemas and tables to MySQL schemas and tables with matching datatypes
Copy rows from MSSQL to MySQL tables
Import constraints and relationships
Import indexes
Import identity columns
Import auto-increment columns
Import default values

Step 1: Prepare Your Databases

If you want to follow along, download the free Trial Edition of Data Loader if you haven't already.

We'll migrate the Microsoft sample Northwind database. If you don't already have it, you can download it from Microsoft's site and install it in MS SQL Server.

First, create a blank target database in MySQL. Start the MySQL Command Line utility:

MySQL Command Line

You'll be prompted for a password — type your root password and press Enter:

Create MySQL database prompt

At the MySQL prompt, create the blank database:

mysql> Create database NorthWind;

Create database

After creating the target MySQL database, start the Data Loader utility.

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

Data Loader Will Automatically

Step 1: Prepare Your Databases