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 Data Examiner

SQL Data Examiner compares and synchronizes the data of the databases. It enables you to migrate data between database servers, consolidate data from slave databases to a master database, and setup scheduled comparison and synchronization.

Runs on: (for desktop): Windows
Data sync: Yes
Schema comare: No
Schema sync: No
Commercial: Commercial
Free edition: No

dbForge Data Compare for MySQL

dbForge Data Compare for MySQL is designed for comparing and synchronizing data in MySQL, Percona, and MariaDB databases. The tool gives a clear picture of differences between data and provides means for analyzing comparison results, generating synchronization script, and applying changes at one stroke.

Runs on: (for desktop): Windows
Data sync: Yes
Schema comare: No
Schema sync: No
Commercial: Commercial
Free edition: No

SQL Delta Duo for MySQL

SQL Delta for MySQL is a tool for comparing and synchronizing schema and data of two MySQL databases side by side.

Runs on: (for desktop): Windows
Data sync: Yes
Schema comare: Yes
Schema sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Schema comare: Yes
Schema sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Schema comare: Yes
Schema sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Schema comare: Yes
Schema sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Schema comare: No
Schema sync: No
Commercial: Commercial
Free edition: No

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: Yes
Schema comare: Yes
Schema sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Schema comare: No
Schema sync: No
Commercial: Commercial
Free edition: No

SelectCompare

SelectCompare is a data comparison utility that lets you compare data from a diverse set of sources. You can write an SQL query to select data for comparison from each or any data source.

Runs on: (for desktop): Windows
Data sync: Yes
Schema comare: No
Schema sync: No
Commercial: Commercial
Free edition: No

DBConvert

Database migration & synchronization software to convert and replicate your data between the most popular databases including MySQL, SQL Server, Oracle, PostgreSQL, and more.

Runs on: (for desktop): Windows
Data sync: Yes
Schema comare: No
Schema sync: -
Commercial: Commercial
Free edition: Yes

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).