SQL Data Compare Professional [Commercial - Support With Update Subscription (2-Years) (9) Users - Electronic *Non-Returnable* Windows]

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.