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.
