» » » » »

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

Published By: Redgate

£1,436.40 (Ex. VAT)

Our Part #: 1009660 | Availability: delivered via Email | Media: Electronic

Description

Editions

SQL Data Compare helps you compare and deploy data changes quickly, simply, and with zero errors. You can work with live databases, backups, or SQL scripts in source control. With the command line interface you can automate tasks and schedule comparisons to easily create an audit trail. Damaged or missing data can be restored to a single row, without the need for a full database recovery.

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.