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