ms sqlmysql

MS SQL to MySQL Migration and Sync

Our database migration software offers powerful and comfortable way to convert and synchronize data from MS SQL to MySQL database. Even with no SQL knowledge you are able to move or replicate data easily.

Incredibly fast database engine of converter is able migrate 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.

Trigger-based synchronization method increases replication speed in times.

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.

Why shifting from SQL Server to MySQL.

  • Cross-platform support: MySQL database can be run on several platforms including Linux, Unix, Windows and Mac OS. If you are one of the *nix guys then there are a plenty of options and MySQL would be a right choice.

  • Cost Effective: MySQL is free open-source database engine. Reasonable price is charged for commercial organizations. Cost factor would be a key point in decision of choosing MySQL for a small business startup.

  • Transparency: Unlimited improvement and tuning of code is possible due to the fact that MySQL is open source.

  • Reliability and stability: A lot of worldwide contributors help to debug and improve MySQL engine constantly. So found bugs can be reported continuously and eliminated effectively.


Move data directly from one server to another or save data into MySQL Dump or PHP script for export to MySQL database. 

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

Trial versions limitations

Product highlights

  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • MS SQL schemes support
  • Saving data into a MS SQL Dump for export to MS SQL database
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • Speed conversion with Bulk and Quantization features
  • 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
  • Ability to connect to MySQL Server 4.x/5.x located on Linux, Solaris, Mac OS X, Windows machines
  • Speed conversion with Bulk and Quantization features
  • Also see common features for all DBConvert tools

Requirements

  • MDAC 2.8
  • 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)
  • 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)
MS SQL MySQL

Converter from
MS SQL to MySQL

  • 8 Oct, 2013
  • Version 4.0.6
ORDER From $149 DOWNLOAD 24.59 Mb

Synchronizer between
MS SQL and MySQL

  • 8 Oct, 2013
  • Version 5.1.5
ORDER From $149 DOWNLOAD 23.81 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From MySQL to MS SQL

Converter+Syncronizer Bundle! Take 25% off regular price

New Features

  • 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.
  • Trigger-based instant synchronization method between MS SQL and MySQL is added.
  • Bidirectional synchronization between MS SQL and MySQL is available.

Screenshots

MS SQL to MySQL: Benefits

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions