Microsoft SQL Server to MySQL Migration.

 DBConvert for MSSQL & MySQL

Version: 4.1.6

Release Date: March 18, 2015

Conversion directions:

  • MS SQL Server → MySQL, MariaDB, MySQL Dump, PHP Script
  • MySQL, MariaDB → MS SQL Server, SQL Azure, MSSQL Dump
  • SQL Azure ↔ MySQL, MariaDB, MS SQL Server
  • MS SQL Server ↔ Amazon RDS ↔ MySQL
  • Views conversion between MS SQL Server and MySQL/ MariaDB
 DBSync for MSSQL & MySQL

Version: 5.3.4

Release Date: June 5, 2015

Synchronization directions:

  • MS SQL Server ↔ MySQL ↔ MariaDB
  • MySQL ↔ SQL Azure ↔ MariaDB
  • MS SQL Server ↔ Amazon RDS ↔ MySQL

DBConvert/ DBSync for MS SQL and MySQL software offers comfortable way to convert and synchronize data from Microsoft SQL Server to MySQL database/ MariaDB. Even with no SQL knowledge you are able to transfer or replicate data easily.

Incredibly fast database conversion engine migrates 1 million records and more in 5-10 min.

Views conversion from MS SQL to MySQL performs automatically and doesn’t require knowing differences between SQL dialects from your side.

Take advantage of Dump files and PHP scripts, when you don't have direct access to a target database server.

You can run conversion/synchronization by scheduler or via command line.

DBSync for MySQL and MS SQL syncs your data between MSSQL to MySQL/ MariaDB and inversely. It performs MSSQL and SQL Azure database synchronization as well.

DBSync for MS SQL and MySQL is really dependable and up-to-date application providing insert, update and drop synchronization as well as other our synchronizers.

Keep all your databases up-to-date with trigger-based synchronization method. "Trigger sync" algorithm is developed for accurate analyzing of destination database data and track changes in both databases instantly. Trigger-based synchronization method increases sync speed in times.

Bi-directional synchronization helps updating data in both source and destination databases simultaneously.

Integrated Data Types Mapping capability assists to match MySQL data types with their closest and relative MS SQL Server equivalents. Read more information about Data types mapping between MS SQL and MySQL.

A question about comparing SQL Server and MySQL pros and cons appeared regularly on various developer resources is quite common one. Actually, it is difficult to say that MS SQL is better than MySQL or vice versa. Comparing them, especially regarding their performance, has no sense. Choosing a database directly depends on experience of database developer or DBA. You can use both of these products to build reliable and efficient systems. MSSQL and MySQL have their own advantages over each other. But there are some good reasons to migrate their databases to MySQL.

Product Highlights

  • MS SQL schemes support
  • Amazon RDS MySQL DB Instance support
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • Speed conversion with Bulk and Quantization features
  • Amazon RDS SQL Server DB Instance support
  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • Views conversion from MySQL to MS SQL and Oracle and back support
  • Saving data into a MySQL Dump and PHP script for export to MySQL database
  • Speed conversion with Bulk and Quantization features
  • Ability to connect to MySQL Server 4.x/5.x located on Linux, Solaris, Mac OS X, Windows machines
  • Saving data into a MS SQL Dump for export to MS SQL database

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

Product Requirements

  • MDAC 2.8
  • Necessary privileges to write into database on the target MySQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)
  • Necessary privileges to write into database on the target MS SQL server (this requirement is optional as there is an option to overcome the restrictions using dump file)

Latest News

  • Trigger-based instant synchronization method between MS SQL and MySQL is added.
  • Bidirectional synchronization between MS SQL and MySQL is available.
  • Parameterized queries added. Synchronization/conversion speed increased approximately by 15%.
  • Added conversion/synchronization for SQL Azure.
  • Stable conversion speed improvements.
    1 million records and more now can be converted in 5-10 min.
  • Added views conversion from MS SQL to MySQL and back.
  • Customizable data filtering.
  • Variable quantization step added.
  • Added CAST CONVERT EXIST and more functions.
  • Added UNION SUBQUERYS states for MySQL.