SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data compare tools
List of data compare, synchronization and migration tools.
Data comparison is a process to inspect the structural differences between the source database and the target one. To carry out the comparison process, databases must meet the conditions of compatibility. However, some comparison tools have the ability to synchronize resources whose original schemas did not match each other.
SQL Server Comparision Tool
SQL Server Comparison Tool analyzes, compares, and documents the structure of tables, procedures, functions, views, triggers, and relationships. It compares data stored in tables and generate detailed reports displaying results of comparisons or analysis.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
DB Ghost Change Manager
DB Ghost provides flexible tools for source scripting, building, comparing, synchronizing, creating delta scripts, upgrading and packaged remote delivery. Compare can also produce Delta scripts between database.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
Altova DatabaseSpy
Altova DatabaseSpy is the unique multi-database query, design, and database comparison tool that even generates elegant charts directly from query results.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
Altova DiffDog
Altova DiffDog is a database content comparison and schema diff/merge tool. It allows you to diff databases of the same type as well as the content of equivalent tables and entire database schemas in different database types.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
Database Comparer Tools
Database Comparer helps to compare, synchronize and update databases structure using highly intelligent and robust synchronization algorithm. You can compare one database with another database or database with SQL/DDL script or even two SQL/DDL scripts.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
DataWeigher
The DataWeigher is the tool to compare and synchronize data. You can select any tables and fields from two MS Access databases and the DataWeigher finds differences. The detected changes can be saved as a report or SQL script to synchronize data.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
Datanamic DataDiff MultiDB
Datanamic DataDiff is a powerful and easy-to-use utility for data comparison and synchronization. It compares data for selected tables in two databases, view differences and publish changes quickly and safely.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
UDB Workbench
UDB Workbench is a tool for DB2 UDB LUW database comparison and synchronization. It allows you connect DB2 UDB databases through ODBC or through schema DDL file, and view all the differences between two connected sources, and execute synchronization script that generated by the tool to synchronize structure of your DB2 UDB databases.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
Nob Hill Database Compare
Nob Hill Database Compare tool performs database comparison both schema and data. With the context-free database scripting engine, you can generate a script that could be run on any database. It will tell you the differences, and change any database to be like the one you are scripting - both schema and data.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
EMS Data Comparer for MySQL
EMS Data Comparer for MySQL is a powerful and easy-to-use tool for MySQL data comparison and synchronization. Using this utility you can view all the differences in compared MySQL tables and execute an automatically generated script to eliminate these differences.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
EMS Data Comparer for SQL Server
EMS Data Comparer for SQL Server is a powerful and easy-to-use tool for SQL Server data comparison and synchronization. Using this utility you can view all the differences in compared SQL Server tables and execute an automatically generated script to eliminate these differences.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
EMS Data Comparer for PostgreSQL
EMS Data Comparer for PostgreSQL is a powerful and easy-to-use tool for PostgreSQL data comparison and synchronization. Flexible customization of the PostgreSQL comparison and synchronization process will enable you to select tables and fields for comparison and perform partial PostgreSQL data synchronization or data comparison for several tables at once.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
EMS Data Comparer for InterBase/Firebird
EMS Data Comparer for InterBase/Firebird is a powerful and easy-to-use tool for InterBase/Firebird data comparison and synchronization. Using this utility you can view all the differences in compared InterBase/Firebird tables and execute an automatically generated script to eliminate these differences.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
EMS Data Comparer for Oracle
EMS Data Comparer for Oracle is a powerful and easy-to-use tool for Oracle data comparison and synchronization. Flexible customization of the Oracle comparison and synchronization process will enable you to select tables and fields for comparison and perform partial Oracle data synchronization or data comparison for several tables at once.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
MssqlMerge
MssqlMerge is an easy to use diff & merge tool for Microsoft SQL Server databases. This tool allows to compare and import/export database objects and data between two databases.
| Runs on: (for desktop): | Windows |
|---|---|
| Data sync: |
|
| Schema comare: |
|
| Schema sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
The core functions provided by data compare tools are:
• Compare and synchronize database from different engines,
• Presentation of comparison results,
• Save a comparison plan.
• Export results as reports to user-friendly formats (HTML, Excell, PDF, etc.),
More advanced tools allow for rich customization options, as well as automation of comparison and sync processes.
Data comparison tools are useful where a comparison of data entries, database schemas and its contents (tables, views, etc.) is required. These tools significantly speed up the time-consuming process of manually searching two or more data resources. What's more, the use of automatic data comparison tools is much more reliable than manual comparison. Typical cases where data compare tools are used:
• Comparison of databases from two or more sources (different platforms are acceptable),
• Comparison of physical resources, with the amount on the page,
• Comparison of customer target groups,
• Other cross-database activities,
In our list, there is a place for free programs, as well as advanced ones, which enables a trial version (with time and/or feature limitations).