Converters for Microsoft SQL Converters for MySQL Converters for IBM DB2 Converters for MS Access Converters for Adobe PDF Converters for DBase/FoxPro Converters for Microsoft Excel Converters for Oracle Converters for Postgres MSSQL-to-Excel Converter MSSQL-to-MySQL Converter Intelligent Converters Software Access-to-MySQL Converter
convert mssql to mysql, ms sql to mysql converter, mssql2mysql, sql-to-mysql, free download
FAQ  |  Site map  |  Contact Us
About Us How to Buy All Products Discounts Migration Service Support Become a Partner Articles

MSSQL to MySQL

[About Migration]  [Release Notes]  [Download]  [Buy]
Latest version 5.3 released 02/20/2012

MSSQL-to-MySQL converter is a tool to migrate Microsoft SQL data to MySQL server. The program guarantees high performance of the conversion process due to direct connection to source and destination databases (it does not use ODBC or any other middleware components). Installation package includes command line version of the product to script, automate and schedule the conversion process.

Features
  • All versions of Unix/Linux and Windows MySQL servers are supported
  • All versions of MS SQL starting from 7.0 are supported
  • Option to append data to an existing MySQL database
  • Special approach for Virtual Server users
  • Option to convert individual tables
  • Indexes with all necessary attributes are converted
  • Option to filter data for conversion with SELECT-queries
  • Foreign keys are converted
  • MS SQL views are converted into MySQL format 
  • Conversion settings can be stored into profile
  • Option to synchronize MySQL database with Microsoft SQL data
  • Multibyte (Unicode) character sets are supported
  • Console version of the converter supports command line parameters
  • Option to export MS SQL data into MySQL dump file
  • Easy-to-use wizard-style interface
  • Quick Launch mode allows to run the conversion with the single click of mouse button
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Stored procedures and triggers are not converted
  • Demo version converts only 5 records per table
  • Demo version does not convert queries/views and foreign keys

Requirements

  • Microsoft SQL environment (server or client components of MS SQL must be installed on the same machine where you run MSSQL-to-MySQL from)
  • Necessary privileges to write into MySQL database
    

Download trial version of MSSQL-to-MySQL

Note for Virtual Server users

Those customers who use virtual server hosting probably do not have sufficient privileges to create new databases on the target MySQL server. For this case Intelligent Converters recommend the following approach:

  1. ask Virtual Server administrator to create blank database
  2. run MSSQL-to-MySQL and select this database as the conversion target
  3. select "Overwrite the entire database" when asked how to process existing MySQL database

After completing these steps the entire contents of source Microsoft SQL database will be imported into the destination MySQL database.

Export into MySQL dump file

MSSQL-to-MySQL can also convert Microsoft SQL data into a local MySQL dump file instead of migrating it to MySQL server directly. This approach gives experienced users more control over the conversion process, for example they can modify table or column names, data types, etc. The dump file contains MySQL statements to create all tables and to fill them with the data. Click here to learn how to import dump file into MySQL database.

Quick Lauch

Once conversion settings are stored into profile user can run MSSQL-to-MySQL converter in "Quick Launch" mode. This scenario can be used by double-clicking on the profile description (.m2s) file with left mouse button from Windows Explorer. Then the wizard will launch the conversion process loading the necessary settings from the specified profile.

MSSQL-to-MySQL is a fantastic program and it has saved me a lot of time and headaches…it was well worth the money that I spent on it! =)
Mullins Brian
Andritz Hydro, http://www.andritz.com

Synchronization

Synchronization in MSSQL-to-MySQL is implemented as combination of insert MS SQL records that are missing in MySQL table and update existing MySQL records with MS SQL data. There are following conditions must be met for synchronization purpose: source and destination tables must have identical structures and have primary key or unique index defined. Let's assume both Microsoft SQL and MySQL databases have table "People" defined as below:

    People(
	ID INT NOT NULL, 
	FName VARCHAR(50),
	LName VARCHAR(50), 
	EMail VARCHAR(50), 
        Primary Key (ID)
    );

This table has the following contents in MS SQL database:

2  Andrew  White a.white@corporation.com
3  Phil  Johnson p.johnson@gmail.com

In MySQL database:

1  John  Smith j.smith@msn.com
2  Andrew  White a.white@yahoo.com

After migrating MS SQL data to MySQL in "Synchronize" mode MS SQL table is kept untouched and MySQL table is modified as (pay attention to the second record):

1  John  Smith j.smith@msn.com
2  Andrew  White a.white@corporation.com
3  Phil  Johnson p.johnson@gmail.com

Try before you buy

Still not sure MSSQL-to-MySQL converter fits your needs? Try free demo version of the product with limited features. It converts only five records per database table, it does NOT convert queries/views and foreign keys. Test the quality of demo version and order the full version if satisfied with the results.

Download trial version of MSSQL-to-MySQL

Ordering

Intelligent Converters software is available directly from the corporate site and a network of resellers worldwide. To order online select the appropriate option in the table below and click the corresponding ORDER NOW link. To learn about alternative payment options please visit Payment Options page.

 

MSSQL-to-MySQL
order single product
$49 ORDER NOW
Two Products Bundle
order MSSQL-to-MySQL + MySQL-to-MSSQL, save $24.5
$73.5 ORDER NOW
MySQL Migration Toolkit
software pack to convert any data source to MySQL
and vice versa
$99 ORDER NOW