Data compare tools

List of data compare, synchronization and migration tools.

Visual Studio - SQL Server Data Tools

SQL Server Data Tools for Visual Studio enables you to analyze and compare database schema and data and apply changes on the target database or to generate T-SQL scripts to run later. Data comparison compares data between two existing databases of the same schema and can write the script to apply the changes.

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

Red Gate SQL Data Compare

SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents. You can work with live databases, backups, or SQL scripts in source control.

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

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 SQL Server

dbForge Data Compare for SQL Server is a powerful SQL comparison tool that easily copes with big data and supports native SQL Server backups. With dbForge Data Compare, you can tune flawless SQL database comparison, quickly analyze SQL data differences and smoothly synchronize SQL Server data with the convenient wizard.

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

dbForge Data Compare for Oracle

dbForge Data Compare for Oracle is a powerful, fast, and easy-to-use tool for Oracle database comparison and synchronization. It helps you quickly compare data in two or more tables, find the differences at a glance, and generate a script to effortlessly synchronize data.

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

dbForge Data Compare for PostgreSQL

dbForge Data Compare for PostgreSQL is a tool for table data comparison and synchronization. With PostgreSQL data compare tool, you can detect data differences in compared PostgreSQL tables. You can also generate data synchronization script and execute it to eliminate all these differences.

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

SQL Admin Studio

SQL Admin Studio is a complete Database Management & Design Environment for SQL Server, MSDE, Express, Access & MySQL. It features schema explorer, backup and restore, query designer, full display script editor with syntax highlighting, Intellisense, table designer, code templates, indexes, constraints, and foreign keys.

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

SQL Delta Duo for SQL Server

SQL Delta for SQL Server runs two or more projects side by side in separate tabs, whether it's two schema compare projects on completely separate servers or a schema compare and data compare project on the same server. It shows an overview of all the objects that are different or not in either the source or target. By selecting each object you can see at the schema level the various differences.

Runs on: (for desktop): Windows
Data sync: Yes
Schema comare: Yes
Schema sync: Yes
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

SQL Delta Duo for Oracle

SQL Delta for Oracle compares two Oracle databases side by side in two separate tabs. It provides comprehensive search and filtering of compare results, filter schema load, two-click synchronize and report on compare.

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

xSQL Data Compare

xSQL Data Compare for SQL Server allows you to compare and synchronize data in SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data, etc.

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

ApexSQL Data Diff

ApexSQL Data Diff compares SQL data from live databases, scripts, backups and source control. It compares SQL database backups without restoring and automates and schedules data migrations.

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

Quest Toad for SQL Server

Quest Toad for SQL Server is a tool that compares and synchronizes schema and data of the SQL Server databases. It easily identifies differences by comparing and syncing servers, schemas, and data and enables a number of scripts to be executed against different servers at the same time.

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

Idera DB Change Manager

DB Change Manager tracks and manages complex database schema changes and complies with database audit and reporting requirements. It protects data privacy within the database environment and track changes from multiple major database platforms.

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