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. 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.
The following review written by one of the Software Informer contributors applies to version 9.1
SQL Data Compare is an application designed to help users compare and synchronize databases stored on SQL Servers or within the SQL Server Management Studio (SSMS). It can also fix problems that occur due to missing or damaged data, by restoring them to a single row.
The most appreciable aspect in this piece of software is the fact that it gives users the possibility to generate copies of database schemas from developers to testers and finally, to production. In other words, SQL Data Compare is able to mend problems caused by any differences that might occur to a specific database schema. Furthermore, in order to give you better control over your information, this utility allows you to create T-SQL script, as well as preserve an accurate history of previous database synchronization.
In order to allow users to personalize their projects, SQL Data Compare comes with numerous settings that you may adjust, and which are grouped under three main fields: “Mapping Behavior”, “Comparison Behavior” and Synchronization Behavior”. In order to apply desired settings to your project, you simply need to access the “Options” menu.
To conclude with, SQL Data Compare proves to be a handy tool, designed to enable comparing database schemas, backups and scripts folders, as well as synchronizations. Because of its user-friendly interface and a great organization of its settings, this utility can be used both by average computer users and well experienced ones.
Easy to use.
Sleek interface.
Numerous setting options.
Restores single or missing data to a single row.
None.
Reviewed by: Marius Viezure
Reviewer rating:
Reviewed: 3 months ago
What's new in version 9.1
SQL Server 2000, 2005, 2008 & SQL Azure databases
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)
What's new in version 9.0
Generate T-SQL scripts to update one database with the contents of another
Quickly fix problems by restoring damaged or missing data to a single row
Keep an accurate history of all previous database records
Compare and synchronize data within SSMS
Deploy to SQL Azure databases
