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.
v11.0 [Oct 11, 2014]
October 6th, 2014
Features
Support for SQL Server 2014 object types
You can use SQL Compare 11 to compare and deploy:
memory-optimized tables
natively compiled stored procedures
memory-optimized table types
Icon
When you deploy a database containing memory-optimized objects (memory-optimized tables, natively compiled stored procedures and memory-optimized table types), we recommend you perform two deployments. See Deploying memory-optimized objects.
clustered columnstore indexes
incremental statistics
Icon
If the ‘Ignore filegroups, partition schemes and partition functions’ project option is selected, the deployment of incremental statistics might fail if they rely on partition schemes or functions which are being ignored.
Backup commands in the deployment script
When you select the 'Back up before deployment' option in the deployment wizard, the backup commands are now included in the deployment script:
This means you can now back up the target when you create a deployment script to run in Management Studio.
Icon
SQL Compare 11 no longer supports SQL Backup Standard or SQL Backup Lite.
‘Do not add error handling statements to deployment scripts’ project option
When you run the deployment script in Management Studio, this option allows the deployment script to fail when an error is encountered. You can only select this option if transactions aren't used in deployment scripts.
When you deploy directly from SQL Compare, the deployment is always terminated when an error is encountered.
Feature-rich relational database known for its high performance and excellent concurrency
