SQL Data Compare

SQL Data Compare boxshot.

SQL Data Compare

Published By:  Redgate

Compare database contents and synchronise changes.

Product Variants

Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.


SQL Data Compare helps you compare and deploy data changes quickly, simply, and with zero errors. You can work with live databases, backups, or SQL scripts in source control. With the command line interface you can automate tasks and schedule comparisons to easily create an audit trail. Damaged or missing data can be restored to a single row, without the need for a full database recovery.

Standard Edition

What can I compare and synchronise?
  • SQL Server 2000, 2005, 2008, SQL Azure, & SQL Server on Amazon RDS databases.

Key Features
  • Compare and deploy changes to SQL Server database contents
  • Compare and synchronise data from within SSMS
  • Automatically create error-free synchronisation scripts
  • Build sophisticated rules to selectively limit what to synchronise
  • Index view support so data differences are seen on both views and tables
  • Comparison on primary keys and unique indexes so you can define identical rows
  • Custom comparison keys to compare databases based on any field
  • Pivot-view difference navigation to display row data as columns
  • Comparison and synchronisation of large databases.

Pro Edition

In addition to the capabilities of the Standard edition, the Pro Edition includes:

What can I compare and synchronise?
  • Native & compressed SQL Server 2008 backup files
  • SQL Server 2000 & 2005 backup files
  • Red Gate SQL Backup files
  • Folders of SQL scripts (for source control).

Key Features
  • Create an audit trail by comparing backups
  • Backup target database before changes are migrated
  • Command line automation for continuous integration (requires an Automation Licence)
  • Fast table, column, or row level restore of damaged or missing data.
Shopping Basket
    0 Item(s)

    View and amend your basket
    ISV Royalty Licensing