| Improved performance |
| Compressed backup comparison Use natively compressed database backups as comparison and synchronization sources |
| SQL Server 2012 support |
Compare and synchronize SQL Server 2012 data. Detect and resolve differences between data stored in FileTables and columnstore indexes
| Improved scalability |
Fully leverage the increased memory limit and performance boosts provided by the x64 architecture
| Support for additional SQL Server objects and data types |
Synchronize data stored in SPARSE columns and FILESTREAM data
| Backup comparison Compare with SQL database backups without restoring. Granularly restore data down to the row level |
| Key-independent comparison Compare data in tables without primary key or UNIQUE constraints with a custom comparison key |
| Pre-impact analysis Review the impact of the database synchronization script before it is executed |
| Custom script integration Augment the deployment script with your own pre or post synchronization scripts |
| Transparent decryption |
Compare data in encrypted objects
| Sophisticated reporting Export the comparison results to HTML reports specifically formatted for browsing and printing |
| Granular control, precision processing Selectively limit what will be compared and synchronized with advanced filtering |
| Customization Specify comparison criteria. Create custom comparison keys |
| Data subsets Build complex filters to compare and sync specific data |
| Smart data mapping Compare data in different SQL objects across environments using object mapping |
| Repeatable sessions Save your options to a project for instant re-execution of the same session |
| Support for all SQL Server versions |
Compare all SQL Server 2012, SQL 2008 R2, SQL 2008, SQL 2005 and SQL 2000 data
System requirements :
| SQL Server | Microsoft SQL Server 2012, 2008, 2005 or 2000 |
| OS | Windows XP and above |
| Required | Microsoft ActiveX Data Access Objects Library (ADO) (MDAC) 2.8 or greater Microsoft .NET Framework 2.0 SP1 Microsoft Windows Script 5.5 or greater |
| Note | Native support for the x64 architecture |