SQL Data Compare

Latest version: 6.1.1

Compares and synchronizes SQL database contents

SQL Data Compare box shot
  • 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.

Walk-throughs

View our short screen-by-screen introductory walk-throughs

View this walk-through

Demo videos

Step-by-step demos of SQL Data Compare in action

View this demo video

SQL Data Compare Pro box shot

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.

SQL Data Compare box shot

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.