Data Loader

MS SQL Server to MySQL Conversion

Data Loader is a powerful tool to Convert, Migrate data from MSSQL to MySQL or from MySQL to MS SQL Server Databases.
It can convert hundreds / thousands of tables in one go. While converting you can map source table columns to matching destination table columns. Filter rows by specifying WHERE conditions. Besides tables, it can also convert Views

Apart from conversion it can also Synchronize data between MS SQL and MySQL using it's own scheduler. It can Update, Insert or delete rows from target tables to match the source tables.
Convert MSSQL to MySQL
It converts Schemas,  Data, Constraints, indexes, Auto Increment and Default Values in just 3 Steps without writing a single line of code.

It automatically chooses the most appropriate Datatypes and widths and also let users to choose their own types

Supports UPSERT loading option. Using this option you can synchronize the data from source to target tables. It will update the row if a matching row exists in the target table else it will insert the row if it doesn't exist

Supports INSERT loading option. With this option Data Loader will insert the row into the target table only if the row doesn't exist in the target table.   

Comes with a built in scheduler so that you can run Conversion jobs at specified intervals. No need to run jobs repeatedly, just create a Session  define the Schedule Date and Time and Data Loader will automatically executes your session in the background and records the actions in a specified log file. You can later on check the log file for information.

It also provides a command line interface to run migration jobs manually so that it can be easily integrated with your own application.

All the sessions are stored in a repository. MSSQL to MySQL Converter provides a user friendly interface to manage repository. Such as taking backup and/or restore repository from a previous backup. You can also create a new blank repository in case you need it.

Besides loading through Conventional method it also support  BULK LOAD method. This method greatly improves the performance and one can load millions of rows in very less time

Download Data LoaderBuy Data Loader

The Most Popular Database Conversion Tool available on the internet.Start MSSQL to MySQL Conversion

Compare the following features which you will not find in any other tool

Using Data Loader you can perform the following conversion

Convert MS SQL Server Views to MySQL Views or MySQL Views to MSSQL

Examples

 MS SQL View

CREATE VIEW "Alphabetical list of products" AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))

automatically converts to MySQL

CREATE OR REPLACE VIEW `Alphabetical list of products` AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))

MSSQL View

CREATE VIEW Invoices AS
SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, 
Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City, 
Customers.Region, Customers.PostalCode, Customers.Country, 
(FirstName + ' ' + LastName) AS Salesperson, 
Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName As ShipperName, 
"Order Details".ProductID, Products.ProductName, "Order Details".UnitPrice, "Order Details".Quantity, 
"Order Details".Discount, 
(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ExtendedPrice, Orders.Freight
FROM Shippers INNER JOIN 
(Products INNER JOIN 
(
(Employees INNER JOIN 
(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) 
ON Employees.EmployeeID = Orders.EmployeeID) 
INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID) 
ON Products.ProductID = "Order Details".ProductID) 
ON Shippers.ShipperID = Orders.ShipVia

automatically converts to MySQL

CREATE OR REPLACE VIEW Invoices AS
SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, 
Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City, 
Customers.Region, Customers.PostalCode, Customers.Country, 
CONCAT(FirstName , ' ' , LastName) AS Salesperson, 
Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName As ShipperName, 
`Order Details`.ProductID, Products.ProductName, `Order Details`.UnitPrice, `Order Details`.Quantity, 
`Order Details`.Discount, 
(CAST((`Order Details`.UnitPrice*Quantity*(1-Discount)/100) AS Decimal)*100) AS ExtendedPrice, Orders.Freight
FROM Shippers INNER JOIN 
(Products INNER JOIN 
(
(Employees INNER JOIN 
(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) 
ON Employees.EmployeeID = Orders.EmployeeID) 
INNER JOIN `Order Details` ON Orders.OrderID = `Order Details`.OrderID) 
ON Products.ProductID = `Order Details`.ProductID) 
ON Shippers.ShipperID = Orders.ShipVia
MSSQL Views converted to MySQL
 

Features

Watch Video Demo of MS SQL Server to MySQL Database Conversion using Data Loader

Advantages of Migrating from MS SQL Server to MySQL

Troubleshooting Connection Problems in Connecting to MySQL

How to convert MS SQL Server database to MySQL using Data Loader. Explained in detail with screenshots