SQL Data Compare™
Latest version: 6.1.1
Compares and synchronizes SQL database contents
- Compare the contents of two databases
- Automatically synchronize your data
- Compare database backup files as if they were live databases
- Row-level data restore
- Get more done each day
SQL Data Compare is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast.
With SQL Data Compare's granular SQL change-scripts you can now restore damaged or missing data to a single row, without the need for a full database recovery, and that means you can fix database problems even faster.
Pro Edition $595
In addition to the below, features include the ability to compare to backups (native SQL Server or SQL Backup) and access to command line interface.
Standard Edition $395
Compares and synchronizes SQL database contents.
With SQL Data Compare Pro, you can compare and synchronize SQL Server live databases with backups or simply compare two backups. With the command line interface you can automate tasks and schedule comparisons for easy compilation of an audit trail.
Find out when and how your data changed by comparing directly to backups. SQL Data Compare will save you many hours which you would otherwise spend copying, restoring and comparing databases with backups by hand; moreover, you can specify exactly which tables, rows, and columns from your databases you want to synchronize.
We have numerous customer testimonials giving details of how much more productive you can be. We also provide stepped solutions for the kinds of problem which you, as a DBA or database developer, may be faced with right now.
Some of the things SQL Data Compare can do for you:
- Verify the success of your data migration
- Create an audit trail by comparing backups
- Restore missing or damaged data at table, row or column levelĀ
- Troubleshoot your replication issues
- Migrate data seamlessly between SQL Server 2000 and SQL Server 2005
- Provide you with an essential QA and documentation tool
- Display row-data in columns (Pivot-view) for faster difference analysis
- Run automated backups before synchronization
- Optional compression of temporary files for improved performance
For comparing and synchronizing database schemas, check out SQL Data Compare's companion product, SQL Compare.






