SQL Data Compare box shot

SQL Data Compare

Feature list

  • Comparison and synchronization of Microsoft SQL Server databases (2000 - 2008), eliminating hours of tedious, manual work.
  • Comparison with backups – native and compressed backup formats of SQL Server 2008 in addition to the backup files of SQL Server 2000 and 2005, and Red Gate's SQL Backup (Pro edition).
  • Fast Row Level Restore of damaged or missing data (Pro edition).
  • Full support for SQL Server 2008, including spatial, temporal and hierarchy data types, sparse columns, and new collations.
  • Full support for SQL Server 2005, including string into XML or CLR data type transformations and CLR, DDL and DML triggers.
  • Comparison on primary keys and unique indexes so you have the flexibility to define identical rows.
  • Custom comparison keys so you can compare databases based on any field – and it doesn't even need to be unique!
  • Support for indexed views so you can view data differences on views as well as tables.
  • 'Pivot-view' difference navigation displays row data as columns for rapid identification and selection of data for synchronization.
  • Comparison and synchronization of large databases – works on databases with thousands of tables and gigabytes of data.
  • Simple to use and hides complexity from the user. Once the comparison has been completed, a script is automatically generated.
  • Integrates with SQL Query Analyzer or SQL Server Management Studio.
  • Option to transport CLR data types as text or binary for increased speed.
  • Mapping allowing you to compare tables, views, or even whole schemas, with different naming allowing for total flexibility.

from $395

($494 including support & upgrades)

  • Download 14-day free trial
  • Create a quote for SQL Data Compare
    • Buy this online
    • Add SQL Data Compare Standard to shopping cart
    • Add SQL Data Compare Pro to shopping cart