Schema Compare v3.0 release notes

Last modified: April 9, 2025

SQL Server 2012 Support

Support for comparison and synchronization of new SQL Server objects:
SEQUENCE
SEARCH PROPERTY LIST
FILETABLE
User accounts synchronization is extended:
Ability to create a user account with password is added
DEFAULT_LANGUAGE setting is added
Ability to create a user account using Windows Principal is added
New properties for SPATIAL INDEX and FULL TEXT INDEX are supported
Synchronization of new database properties is added

SQL Azure Support

The new version of Schema Compare for SQL Server makes development and maintenance of databases on SQL Azure services easier and more convenient. Now you can establish a connection with a remote server and perform comparison and synchronization of data schema with your remote server as easily as with a local network server.

New Synchronization Features

Manual resolving of conflicts on creating NOT NULL restrictions functionality is added
‘Add constraints and keys to tables using NOCHECK’ synchronization option is added
‘Ignore user DEFAULT_SCHEMA’ option is added
Ability to synchronize assemblies through files on disks is added
Checking if the USE command was executed correctly is added to synchronization script
Ability to load synchronization script to SQL Server Management Studio is added
Information on database properties that can be synchronized shown in Action Plan is extended - now it contains a record on each parameter that can be changed
Synchronization of changes made to Service Broker for Queue (for SQL Server 2008 R2) is added

UI Improvements

Ability to search Action Plan is added
Search in comparison options and comparison document is improved - on entering values into the search field, search results are highlighted
Description field for options in the comparison and synchronization wizards is added
Product start page improved