SQL Server Migration & Synchronization

SQL Server is a relational database management system developed by Microsoft. It combines a very user-friendly interface with low-cost entry-level configurations. To get all benefits of the most advanced and the most enhanced SQL Server versions coming to market, organizations often decide to migrate to SQL Server (hosted in Azure SQL cloud or on-premise).

Three SQL Server migration paths to go.

  1. It would be an obvious choice to migrate overgrown Access databases or obsolete FoxPro data to on-premises SQL Server as they are all produced by the same vendor.
  2. However, for large data storage volumes with many clients, it would be reasonable to consider migrating a database to cloud-based solutions like:
  3. Keeping the same database type as the on-premises database when moving to the cloud lets reduce the maintenance cost of a self-managed database server.

    If increasing SQL Server licensing costs becomes an issue, migration to free PostgreSQL or Firebird databases might be another way to go.

Mgration between SQL Server and other DBMS

Synchronize SQL Server database.

Once you shifted your source database to the target database, you might want to synchronize your databases. This can be achieved by checking one database for updates and then applying them to another database. The source you are migrating continues to change after the initial migration occurs. It drifts from the target database in terms of data and schema.

SQL Server DBSync tools serve to perform Update, Insert, and Drop synchronization to keep your source and target databases in sync.

Sync SQL Server databases with Azure cloud or configure one of the DBSync products listed on this page to synchronize SQL Server databases with other clouds or many on-premises database types.

Also, DBSync software is enhanced by bidirectional replication between SQL Server and other databases. In this scenario, two different databases simultaneously replicate changes from each other.

Homogenous vs. heterogeneous database migrations.

Depending on the need, you can shift your database either to the same type of database or to a new kind of database.

Why move to the same type of database?

  • You're upgrading an on-premises SQL Server to a later version of on-premises SQL Server.
  • Move your data from on-premises SQL Server to Azure SQL cloud.
  • Convert databases in the opposite direction from Azure SQL to on-premises SQL Server is also possible.
  • Synchronize on-premises SQL Server databases.
  • Sync on-premises SQL Server to Azure Database.

Note: You can choose any software listed below to perform homogenous database conversion or sync operations. As a bonus, you get one more database which you can select as a source or target.

Why shift to the new kind of database?

For businesses that require switching to another type of database, we offer DBConvert and DBSync heterogeneous cross-database migration software solutions.

To migrate and sync your data between SQL Server and the most popular directions like MySQL, Oracle, Postgres, choose a required migration or synchronization tool from the list at the bottom of the page.

Note: All DBConvert software from the list below performs database migration or sync in both directions:

  • SQL Server to Any Database;
  • Any database to SQL Server;

Why use software from DBConvert for SQL Server migration and Synchronization?

Although you can use the SQL Server Migration Assistant to automate database migration from multiple DBMSs to SQL Server, they have some drawbacks. DBConvert products address these shortcomings.

  1. SSMA migration tools can migrate data in one direction only when the target database is SQL Server. In DBConvert, you can easily set SQL Server as a source and another database as a target when migrating or syncing databases.
  2. At the moment of writing, the SQL Server Migration Assistant has a limited number of source databases to choose from. Refer to the table below to see the list of supported databases.
  3. SQL Server Migration Assistant DBConvert Applications
    Access Access
    DB2 DB2
    MySQL MySQL
    Oracle Oracle
    - PostgreSQL
    - FoxPro
    - SQlite
    - Firebird / Interbase
    - Excel
DBConvert for Access & MSSQL

Version: 6.1.1

Release date: June 23, 2020

Conversion directions:

  • Access x86/x64 → MS SQL Server, MS SQL Dump
  • MS SQL Server → Access 32/64
  • Access queries → MS SQL Server views
  • Access 32/64 ↔ SQL Azure
  • Access x86/x64 ↔ Amazon RDS
DBConvert for MSSQL & MySQL

Version: 4.2.7

Release date: Oct. 3, 2018

Conversion directions:

  • SQL Server → MySQL | MariaDB | Percona
  • MySQL | MariaDB | Percona → SQL Server
  • SQL Servet ↔ Azure Database for MySQL
  • SQL Azure ↔ MySQL | MariaDB | Percona | SQL Server
  • SQL Server ↔ Amazon RDS | Aurora ↔ MySQL
  • ☑ Views conversion between SQL Server and MySQL/ MariaDB
  • SQL Server ↔ Google Cloud ↔ MySQL
  • MSSQL ↔ MySQL Dump, PHP Script
  • MySQL ↔ SQL Azure, SQL Server Dump
DBConvert for MSSQL & PostgreSQL

Version: 3.6.2

Release date: June 15, 2018

Conversion directions:

  • MS SQL Server → PostgreSQL, MS SQL Dump, PostgreSQL Dump, PHP Script
  • PostgreSQL → MS SQL Server, MS SQL Dump, PostgreSQL Dump, PHP Script
  • PostgreSQL ↔ SQL Azure
  • MS SQL Server ↔ Amazon RDS ↔ PostgreSQL
  • MS SQL Server ↔ Heroku Postgres ↔ PostgreSQL
DBConvert for MSSQL & DB2

Version: 2.1.1

Release date: Aug. 12, 2019

Conversion directions:

  • DB2 → MS SQL Server, MS SQL Dump
  • MS SQL Server → DB2, MS SQL Dump
  • DB2 ↔ SQL Azure
  • IBM DB2 ↔ Amazon RDS
DBConvert for FoxPro & MSSQL

Version: 4.6.9

Release date: Sept. 14, 2020

Conversion directions:

  • MS Visual FoxPro → MS SQL Server, MS SQL Dump, MS Visual FoxPro Program
  • MS SQL Server → Visual FoxPro, FoxPro 2.6, MS Visual FoxPro Program, MS SQL Dump, *.DBF
  • FoxPro ↔ SQL Azure
  • MS Visual FoxPro, *.DBF ↔ Amazon RDS
DBConvert for SQLite & MSSQL

Version: 1.6.2

Release date: Feb. 15, 2019

Conversion directions:

  • SQLite → MS SQL Server, MS SQL Dump
  • SQL Server → SQLite, MS SQL Dump
  • SQLite ↔ SQL Azure
  • SQLite ↔ Amazon RDS
  • SQLite ↔ Google Cloud
DBConvert for Firebird & MSSQL

Version: 2.1.6

Release date: March 11, 2019

Conversion directions:

  • Firebird → MS SQL Server, MS SQL Dump, Firebird Dump, InterBase
  • MS SQL Server → Firebird, MS SQL Dump, Firebird Dump, InterBase
  • InterBase → MS SQL Server, MS SQL Dump, Firebird, Firebird Dump
  • Firebird ↔ SQL Azure
  • Firebird ↔ Amazon RDS ↔ Interbase
DBConvert for Oracle & MSSQL

Version: 2.1.4

Release date: Feb. 12, 2020

Conversion directions:

  • Oracle ↔ SQL Server
  • Oracle ↔ Azure SQL DB | Azure SQL Data Warehouse
  • Oracle ↔ Amazon RDS ↔ SQL Server
  • Oracle ↔ Google Cloud SQL for SQL Server
  • ☑ Migrate to SQL Server Dump | Oracle Dump
  • ☑ Oracle views ↔ SQL Server views
DBConvert for Excel & MSSQL

Version: 1.4.2

Release date: Feb. 21, 2018

Conversion directions:

  • Excel → MS SQL Server, MS SQL Dump
  • MS SQL Server → Excel, MS SQL Dump
  • Excel ↔ Amazon RDS
DBSync for Access & MSSQL

Version: 4.1.3

Release date: Jan. 15, 2020

Synchronization directions:

  • Access ↔ MS SQL Server
  • Access ↔ SQL Azure
  • MS SQL Server ↔ SQL Azure
  • Access ↔ Amazon RDS
DBSync for MSSQL & MySQL

Version: 5.4.3

Release date: Oct. 3, 2018

Synchronization directions:

  • SQL Server ↔ MySQL ↔ MariaDB | Percona
  • MySQL ↔ SQL Azure | Aurora ↔ MariaDB
  • SQL Server ↔ Amazon RDS | Aurora ↔ MySQL
  • SQL Server ↔ Google Cloud ↔ MySQL
DBSync for MSSQL & PostgreSQL

Version: 2.9.4

Release date: Oct. 24, 2019

Synchronization directions:

  • MS SQL Server ↔ PostgreSQL
  • PostgreSQL ↔ SQL Azure
  • MS SQL Server ↔ Amazon RDS ↔ PostgreSQL
  • MS SQL Server ↔ Heroku Postgres ↔ PostgreSQL
DBSync for MSSQL & DB2

Version: 2.0.6

Release date: July 15, 2019

Synchronization directions:

  • DB2 ↔ MS SQL Server
  • DB2 ↔ MS SQL Azure
  • IBM DB2 ↔ Amazon RDS
DBSync for FoxPro & MSSQL

Version: 4.6.5

Release date: Sept. 25, 2020

Synchronization directions:

  • FoxPro → MS SQL Server
  • MS SQL Server → MS Visual FoxPro, *.DBF
  • *.DBF → MS SQL Server
  • FoxPro ↔ SQL Azure
  • MS Visual FoxPro, *.DBF ↔ Amazon RDS
DBSync for SQLite & MSSQL

Version: 1.5.1

Release date: April 28, 2020

Synchronization directions:

  • SQLite ↔ Microsoft SQL Server
  • SQLite ↔ SQL Azure
  • SQLite ↔ Amazon RDS
DBSync for Firebird & MSSQL

Version: 2.1.5

Release date: March 11, 2019

Synchronization directions:

  • Firebird → MS SQL Server, InterBase
  • MS SQL Server → Firebird, InterBase
  • InterBase → MS SQL, Firebird
  • Firebird ↔ SQL Azure
  • Firebird ↔ Amazon RDS ↔ Interbase
DBSync for Oracle & MSSQL

Version: 1.4.1

Release date: Nov. 14, 2018

Synchronization directions:

  • SQL Server ↔ Oracle
  • Azure SQL DB | Azure SQL Data Warehouse ↔ Oracle
  • SQL Server ↔ Amazon RDS ↔ Oracle
  • Google Cloud SQL for SQL Server ↔ Oracle