SQL Data Compare™
Feature list
- Comparison and synchronization of Microsoft SQL Server databases, eliminating hours of tedious, manual work.
- Comparison with backups – native SQL Server or Red Gate SQL Backup, enabling fast Row Level Restore of damaged or missing data (Pro edition).
- Full support for SQL Server 2005, including string into XML or CLR data type transformations and CLR, DDL and DML triggers.
- Comparison of backups so you can compile comprehensive audit trail within a fraction of the time and get on with more useful tasks.
- 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.
