MySQL to MSSQL

[FAQ]  [Release Notes]  [Download]  [Buy] Latest version 5.1 released 01/23/2012

MySQL to MSSQL converter is a tool to migrate MySQL databases to Microsoft SQL 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). Command line support allows to script, automate and schedule the conversion process.

Features All versions of Unix and Windows MySQL are supported All versions of Microsoft SQL server starting from 7.0 are supported Option to convert individual tables Option to synchronize MS SQL database with MySQL data Option to filter data to convert via SELECT-queries Option to append MySQL data into an existing MS SQL database Indexes with all necessary attributes are converted Foreign keys are converted MySQL views are converted into Microsoft SQL format Conversion settings are stored into profile Multibyte (Unicode) character sets are supported Console version of the converter supports command line parameters 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 Necessary privileges to write into MS SQL database Microsoft SQL environment (server or client components of MS SQL must be installed on the same machine where you run MySQL to MSSQL from)

Synchronization

Synchronization in MySQL to MSSQL is implemented as combination of insert MySQL records that are missing in Microsoft SQL table and update existing MS SQL records with MySQL 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 that 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)
    );
              

Quick Lauch

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

Try before you buy

Still not sure that MySQL to MSSQL 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.  

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.

MySQL to MSSQL order single product		$49		ORDER NOW
Two Products Bundle order MySQL to MSSQL + MSSQL to MySQL, 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