MySQL to SQL Server Migration.

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.

 DBConvert for MSSQL & MySQL

Migration 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 | Aurora ↔ MySQL
  • Views conversion between MS SQL Server and MySQL/ MariaDB
  • MS SQL Server ↔ Google Cloud ↔ MySQL

Version: 4.2.7

Release Date: Oct. 3, 2018

 DBSync for MSSQL & MySQL

Sync directions:

  • MS SQL Server ↔ MySQL ↔ MariaDB
  • MySQL ↔ SQL Azure | Aurora ↔ MariaDB
  • MS SQL Server ↔ Amazon RDS | Aurora ↔ MySQL
  • MS SQL Server ↔ Google Cloud ↔ MySQL

Version: 5.4.3

Release Date: Oct. 3, 2018

Supported OS:

Related Links

GUI Application.

Use DBConvert / DBSync software GUI application to configure parameters for starting a migration process.

In general, the following 4 steps are required to perform conversion or synchronization

  1. Choose Source Database.
  2. Choose Destination Database.
  3. Custoimzation and configuration.
  4. Execution.

Optionally save connection settings and configuration parameters into the session file to schedule the launching of sync or migration jobs regularly.

The screenshot below sums up general features available in DBConvert software solutions.

Command line mode

Previously saved sessions can be passed as parameters to Command-Line DBConvert Client. A session keeps source/ target DB connection settings and other specified options.

Example: C:\Program Files\DBConvert\mssql2mysqlPro\mssql2mysqlPro_Cons.exe /Session:"Session_Name"

NOTE: First, you have to run the software in GUI mode to create a session file with initial parameters.

Built-in scheduler.

Our applications come with a built-in scheduler to run database migration and sync jobs at specified times. Just set the scheduled date and time to execute job sessions automatically.

DBConvert screenshot

Highlights

Requirements

  • Necessary privileges to write into database on the target 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)

Try All-in-one DB migration and Sync software.

DBConvert Studio

 Version: 1.7.8

Release Date: June 21, 2020

Supported databases:

  • SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • Access
  • FoxPro
  • SQLite
  • Firebird
  • Excel
  • IBM DB2
  • MS Azure SQL
  • Amazon RDS
  • Heroku Postgres
  • Google Cloud