What's New in dbForge Schema Compare for SQL Server, v4.2

The update brings support for SQL Server 2016 and SSMS 2016 in addition to other improvements and small bug fixes.

Support for MS SQL Server 2016 and its backup

dbForge Data Compare for SQL Server now supports the new functionality of SQL Server 2016. Specifically, supported are:

  • Query Store providing performance-tuning capabilities allowing you to monitor queries, query plans, runtime statistics, and more.
  • Database Scoped Configuration allowing to configure the behavior of the application code at the database level.

SQL Server 2016 supported in dbForge Schema Compare for SQL Server

Database Scoped Configuration supported

This feature gives you the ability to configure certain database parameters at the database level that before was only possible at a server level.

Database Scoped Configuration supported in dbForge Schema Compare for SQL Server

New comparison options

Many new options were added to the schema comparison wizard so you can customize a comparison process to meet your specific needs.

Comparison options:

  • Ignore user DEFAULT_LANGUAGE
  • Ignore Database Extended Properties
  • Ignore replication triggers
  • Ignore Replicated Tables
  • Ignore users' permissions and role memberships
  • Ignore replication procedures
  • Ignore replication role
  • Ignore replication schema
  • Ignore INSTEAD OF triggers
  • Ignore database and server name in synonyms
  • Ignore Constraint System Names
  • Ignore DML and INSTEAD OF triggers present only in Target
  • Ignore indexes present only in Target
  • Ignore tSQLt Framework And Tests
  • Ignore sequences properties
  • Ignore next filegroups in partition schemes
  • Ignore Triggers State
  • Ignore Bound rules and defaults
  • Ignore WITH NOCHECK state on constraint
  • Ignore Foreign keys actions ON UPDATE and ON DELETE
  • Ignore NOT NULL Constraint
  • Convert UDTs into SQL Server basic datetypes
  • Ignore Table LOCK_ESCLATION
  • Ignore WITH ENCRYPTION
  • Ignore Semicolons
  • Ignore spaces in object names
  • Ignore object names in definitions
  • Associate column names having similar name options, %
  • Ignore Synchronization Script for Databases
dbForge Schema Compare for SQL Server comparison options

Synchronization options added

  • Use DROP and CREATE instead of ALTER
  • Add error handling statements to synchronization script
  • COMPRESS BACKUP
  • Add WITH ENCRYPTION
  • BACKUP TYPE
  • Transaction Isolation Level
dbForge Schema Compare for SQL Server synchronization options

Improved synchronization logging

On the command line, the /log argument now sends the results of schema synchronization to a log file. Specifically, all errors and informational messages during the command line schema synchronization process are recorded to the file.

Synchronization logging is better in dbForge Schema Compare for SQL Server

DROP IF EXISTS is used instead of DROP on MS SQL Server 2016

This command greatly simplifies routine operations and minimizes written code. What is more, if the object doesn’t exist, you will not get any error and the execution will continue.

DROP IF EXISTS is used instead of DROP on MS SQL Server 2016

Integration into Microsoft Management Studio for SQL Server 2016 supported

dbForge Schema Compare for SQL Server seamlessly integrates into Microsoft SQL Server Management Studio 2016, so you can compare and synchronize SQL databases directly from the most recent SSMS version available.

Integration into Microsoft Management Studio for SQL Server 2016 supported

Command-line client support for Version Control

This feature lets you automate source control operations for any source control system. A preset config file is provided for Plastic SCM and Mercurial (example). You can create your own config file using the Command Line Interaction option.

Command-line client support for Version Control

For a complete list of changes, see the revision history.