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