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 mysql to ms sql, mysql to sql converter, sql2mss, mysql2mssql, free download, shareware
FAQ  |  Site map  |  Contact Us
About Us How to Buy All Products Discounts Migration Service Support Become a Partner Articles

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)
    
Start Page Connect to MySQL server
Select database Conversion Progress

Download trial version of MySQL to MSSQL

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)
    );
              

This table has the following contents in MySQL database:

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

In MSSQL database:

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

After migrating MySQL data to MSSQL in "Synchronize" mode MySQL table is kept untouched and MS SQL 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

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.  

Download trial version of MySQL to MSSQL

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
access to mysql excel to sql mysql access mysql oracle mysql to sql oracle to access oracle mysql sql to mysql