MySQL to Microsoft SQL Server 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

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa
 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

Interface languages

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

DBConvert/ DBSync software automates conversion and synchronization of your data from MySQL to Microsoft SQL Server. Transfer the entire database or select only needed dataset at customization stage in easy-to-use wizard style GUI.

Views migration between MS SQL Server and MySQL in both directions is possible. You don’t need to know any differences in SQL syntax. Every view will be converted from source db to target automatically.

Integrated Data Types Mapping feature helps to find and map similar data types between MySQL/ MariaDB and MS SQL Server to make cross database conversion more flexible. Read more info about Data types mapping between MySQL and MS SQL Server.

So if you decided to choosing Microsoft SQL Server as a back-end for your application or need to replicate/ synchronize data between MySQL and MS SQL DBMS, here you can find solutions for automating your migration jobs.

There is an option to put the result into a dump file instead of transferring it directly to another MS SQL database.

Trigger-based synchronization method helps increase the speed of data comparing and replication significantly.

Use built-in Scheduler to automatically launch the conversion and synchronization tasks.

Product Highlights

  • 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
  • MS SQL schemes support
  • Saving data into a MySQL Dump and PHP script for export to MySQL database
  • Speed conversion with Bulk and Quantization features
  • Views conversion from MySQL to MS SQL and Oracle and back support
  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • Amazon RDS SQL Server DB Instance support
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • Amazon RDS MySQL DB Instance support
  • 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

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.