Released: Apr 23, 2019

Updates in 13.7.10

Features

• Role and user modifications will now usually be done within the transaction rather than beforehand (unless they must be done beforehand because of limitations of SQL 2005/8 or full text objects depending on them).
• Partition Schemes now select their dependencies if Include Dependencies is specified and Ignore Filegroups is turned off. Table drops will generate a High warning if generated.

Released: Feb 4, 2019

Updates in 13.6.14

Features

• Adds a new option to ignore sensitivity classifications on fields.
• Additional logging of .NET assembly loading to help investigate SDC-2906.

Fixes

• SC-10397: SQL Compare now sets the correct value for NATIVE_COMPILATION when reading from a scripts folder.
• SC-10398: Fixed a snapshot deserialization crash for case differences in column names between temporal and history tables.
• SC-10402: Dropping temporal tables with columns that depend on a user defined type no longer throw an exception.

Released: Oct 15, 2018

Updates in 13.6

Features

• SQL Compare now supports comparison and deployment of sensitivity classifications
• SQL Data Compare options can now be specified with the /datacompareoptions switch when deploying static data through the SQL Compare command line.

Fixes

• SC-10264: User defined types that are dependencies will no longer be deployed if the option to include dependencies is not set.
• The DataFileSet node of the RedGateDatabaseInfo.xml file in a scripts folder has been deprecated and no longer affects static...

Released: Sep 17, 2018

Updates in 13.5

Features

• Added support for using SQL Change Automation projects as a data source in SQL Compare.

Fixes

• A create index statement with a string literal as a filegroup name will no longer cause a parser error.
• Fixed the sca2 command-line parameter not being recognised.
• SQL Compare no longer explicitly deploys default data spaces.
• SQL Compare command line no longer normalises all line endings to CRLF when adding static data.

Released: Jun 25, 2018

Updates in 13.4

Features

• Adds an "Ignore Change Tracking" option
• The "Ignore authorization on schema objects" option now also includes schemas themselves.

Fixes

• SQL Compare no longer creates SET statements in the context of creating a scripts folder, when filtered indexes are included.
• Parse error on AT TIME ZONE with bracketed string literal fixed.
• Deploying a varchar(4096) column or wider onto a varchar(MAX) no longer gives spurious warning about truncation. Deploying in the other direction gives the correct...

Released: Jun 4, 2018

Updates in 13.3

Features

• Supports external language event types, which are now available on Azure.
• Now handles ADD_SENSITIVITY_CLASSIFICATION and DROP_SENSITIVITY_CLASSIFICATION event types.
• Command line now includes switches /activedirectory1 and /activedirectory2 to specify the use of Azure Active Directory authentication.

Fixes

• "Ignore whitespace" option is no longer applied to string literals.
• CLR triggers will now be deployed if an assembly they require is rebuilt and Include Dependencies is on.
• The 'DROP...

Released: Jan 30, 2018

Updates in 13.1.10

Features

• Handles filegroups defined on a fulltext index.
• Handles user defined and customized history tables for temporal tables, and will store all history tables in scripts folders.
• Integrates the Redgate bulk uninstaller.
• SQL Compare Command Line now runs in 64-bit mode by default.

Fixes

• SQL Compare no longer displays a blank warning dialog when asking to overwrite the existing comparison report
• SQL Compare doesn't duplicate index creation on history tables.
• SQL Compare can deploy history...

Released: Oct 30, 2017

Updates in 13.1.x

Features

• Improved logging capabilities
• SQL Compare now generates a new style of HTML report, to match the reports produced by other Redgate products.

Fixes

• SC-9781: SQL Compare can deploy temporal tables from a scripts folder to a live database.
• SC-8880: Scripts folders can now be in the root of a drive (as long as it is otherwise empty)
• SC-9775: On the command-line, in the absence of a -reporttype switch, SQL Compare now correctly uses the -report switch to infer the report type, based on the...