FAQ  |  Site map  |  Contact Us
About Us How to Buy Products Discounts Migration Service Support Become a Partner Articles

MySQL to MSSQL


Latest version 7.1 released 04/24/2017

MySQL-to-MSSQL converter is a tool to migrate MySQL databases to SQL server or Azure SQL. 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

  • MySQL to MS SQL converter works with all versions of MySQL running on Linux, Unix and Windows platforms
  • All versions of MS SQL are supported including Azure SQL
  • The program converts indexes and foreign keys with all necessary attributes
  • Option to synchronize MS SQL database with MySQL data
  • Option to filter data to convert via SELECT-queries
  • Option to export MySQL database into T-SQL script 
  • Option to convert individual tables
  • MySQL views are converted into Microsoft SQL format
  • Conversion settings are stored into profile
  • Unicode is 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 50 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)
    

Download trial version of MySQL-to-MSSQL

Synchronization

Synchronization in MySQL to MS SQL converter 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
  • primary key or unique index is defined

It can take some time since the program scans entire source and destination tables in order to find all rows that have been changed.

If you need more options to configure the synchronization or want to reduce duration of the process via "incremental" technique, take a look on MSSQL-MySQL Sync, special product to synchronize MS SQL and MySQL databases.

Export into T-SQL script file

Sometimes SQL Server or Azure SQL may not allow remote access. For this cases MySQL to MS SQL converter provides option to export MySQL data into a local T-SQL script file instead of moving it to MS SQL server directly. This file contains SQL statements to create all tables and to fill them with the data. This article explains how to import T-SQL script file to SQL Server.

Quick Lauch

Once conversion settings are stored into profile, user can run MySQL to MS SQL converter 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 50 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

 

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