redgate SQL DATA Compare

redgate SQL DATA Compare

Compare and deploy SQL Server database contents

SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents.

You can work with live databases, backups, or SQL scripts in source control. Damaged or missing data can be restored to a single row, without the need for a full database recovery.

SQL Data Compare helps you compare and deploy changes quickly, simply, and with zero errors.

STANDARD

per user

Compares and synchronizes SQL Server database contents

PRO

per user

Automate comparisons and migrations, and recover individual rows by comparing databases to backups

Key features

Do all this with SQL Data Compare Standard

Save time comparing and synchronizing data

Copy lookup data from development databases to staging or production

Generate T-SQL scripts to update one database with the contents of another

Keep an accurate history of all previous database records

Compare and synchronize data from within SQL Server Management Studio

Deploy to SQL Server, SQL Azure, and SQL Server on Amazon RDS

Do even more with SQL Data Compare Pro

Quickly fix problems by restoring damaged or missing data to a single row

Deploy databases from source control

Compare and synchronize from backup files

Automate comparison and synchronization tasks with DLM Automation

Run SQL Data Compare Pro on your build server for continuous integration, with DLM Automation

Screenshots

 

 

 

Select what you want to compare

 

Select data to deploy

 

Create a manual deployment script

 

The databases are identical

 

Compare and manually deploy database contents from within SSMS