Released: Sep 1, 2016

Updates in V7.0

Features

• Support for SQL Server 2016.
• New Schema Compare Options - SQL schema compare now supports several new compare options such as compare security policies, compare column master keys/encryption/mask, compare system versioning, compare hash index bucket count, and compare remote data archiving.
• Command Line Wizard - Allows the user to create a command line xml file step-by-step, via a simple and intuitive interface.
• New Data Compare Options - SQL data compare now supports several new compare options such as compare system versioned tables and compare stretched tables.

Fixes

• Schema Compare:
  • Fixes an issue with the SPARSE column. The NULL|NOT NULL constraints should be specified after the SPARSE attribute.
  • Fixes an issue that occurred when the synchronization script contains extended characters, such as Chinese letters. Schema now uses UTF-8 encoding for the script and the log files.
  • Fixes an issue with the DATA_COMPRESSION attribute on a filestream table. If the filestream table contains an embedded primary key, data compression must be specified either under the primary key or the table, but not both.