13.6.14.9174 - February 4th 2019

FREQUENT UPDATES RELEASE

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

13.6.13.9079 - January 31st 2019

FREQUENT UPDATES RELEASE

Fixes

• SC-10382: Clustered columnstore indexes are no longer rebuilt when adding a column to a table
• SC-5024: SQL Compare now reads the correct value for TRACK_COLUMNS_UPDATED from a scripts folder
• SC-10398: Fixed a snapshot deserialization crash for case differences in column names between temporal and history tables

13.6.12.9031 - January 28th 2019

FREQUENT UPDATES RELEASE

Fixes

• SC-10386: Fixed a crash when saving filetables to snapshot
• SC-10387: Fixed a crash when loading filetables from snapshot
• SC-10385: SQL Compare no longer unnecessarily rebuilds graph tables when the "Force column order" option is set
• SC-10306: SQL Compare no longer throws an exception when comparing mapped tables with check constraints

13.6.11.8947 - January 23rd 2019

Fixes

• Fixed an issue with SOC integration

13.6.10.8927 - January 22nd 2019

FREQUENT UPDATES RELEASE

Fixes

• SC-10357: Scripts folders containing POISON_MESSAGE_HANDLING statements in queue alters can now be registered
• SC-10157: we now deploy bound rule/default changes with UDT changes, so that incompatible rules and defaults no longer prevent use of the UDT
• SC-10375: When comparing a normal table to a temporal table, the SQL for the normal table now correctly matches up with the temporal table SQL rather than the history table SQL in the diff view

13.6.9.8731 - January 14th 2019

FREQUENT UPDATES RELEASE

Fixes

• SC-10353: SQL Compare no longer duplicates comments that follow an OR keyword when generating a deployment script
• SC-10365: Rebuild calculation for graph tables no longer crashes when comparing a live source to a scripts folder
• SC-10366: SQL Compare can now read indexes on hidden columns of graph tables from a scripts folder
• SC-10373 Comparing an NVARCHAR(MAX) to a VARCHAR(x) for x > 4000 no longer gives spurious truncation warning
• SC-10373 Comparing VARCHAR/CHAR to NVARCHAR/NCHAR will give warning about potential Unicode corruption

13.6.8.8602 - January 8th 2019

FREQUENT UPDATES RELEASE

Features

• SQL Compare now puts the commented out SQL for keys at the top of the script, along with certificates, so they are easier to spot.

Fixes

• SC-9815: SQL Compare will now not overwrite the RedGateDatabaseInfo.xml with default options when deploying from the command line
• SC-10319: SQL Compare recognises primary keys on filetables so they can be referenced by other objects
• SC-10339: Adding a column to a table with a history table doesn't attempt to re-create an existing index
• SC-10351: SQL Compare now successfully parses the PREDICT function
• SC-10355: SQL Compare can now read more than one sensitivity classification per table in a scripts folder
• SC-10360: SQL Compare no longer throws an exception when a stored procedure ends in a SET ANSI_NULLS statement and certain options are set
• SC-10369: SQL Compare will now deploy permissions to the history tables of temporal tables
• SC-10371: SQL Compare now correctly redeploys multiple predicates that depend on the same function and apply to the same table

13.6.7.8464 - December 18th 2018

FREQUENT UPDATES RELEASE

Fixes

• SC-10321: SQL Compare will no longer attempt to create an index on a view without dropping it when triggered by only a change in an assembly
• SC-10336: Unique indexes on memory optimized tables now stay unique when deployed to scripts folders

13.6.6.8387 - December 11th 2018

FREQUENT UPDATES RELEASE

Fixes

• SC-10323: SQL Compare now handles column definitions containing TRIM
• SC-10303: SQL Compare no longer ignores permissions on domain users
• SC-10271: SQL Compare now refreshes relevant views after unbinding user-defined data types from tables in order to safely modify the type
• SC-10031: SQL Compare doesn't highlight differences between CREATE and CREATE OR ALTER statements
• SC-10311: SQL Compare now respects dependencies correctly when a user defined type and a table have the same name
• Unbinding XML Schema Collection from a table now shows up as a dependency in the UI dependency list
• SC-10333: SQL Compare can now parse aliases with missing column lists in nested SELECT statements
• SC-10338: Fixed some confusion between permissions on tables and types that have the same name

13.6.5.8288 - November 26th 2018

FREQUENT UPDATES RELEASE

Features

• SC-10288: Added an option to add NO POPULATION to fulltext indexes on creation, so that population can be started at a better time than deployment time

Fixes

• XML Schema Collections on UDTTs now have dependencies treated correctly and don't produce an exception in the deployment wizard
• Fixed some deployment crashes when certain changes are queued multiple times
• SC-9552: Apply the correct filter on initial load of a project when the filter has been loaded from the data source
• SC-9907: Don't generate an ALTER statement for a sequence which only has permission changes
• SC-10299: Double precision data types can now be parsed with a length parameter
• SC-10302: SQL Compare can now parse stored procedures that manipulate security policies

13.6.4.8233 - November 21st 2018

FREQUENT UPDATES RELEASE

Fixes

• SC-10298: Filters are now correctly loaded from a SoC checkout
• SC-10262: SQL Compare doesn't attempt to update default values in a non-nullable column before the default value has been added
• SC-10300: SQL Compare can create a snapshot from a SQL Change Automation project using the command line
• SC-10274: SQL Compare can alter multiple computed columns that depend on the same column when altering the column type
• SC-10276: SQL Compare handles altering the primary key while creating/dropping columns in a temporal table
• No longer has a specific warning for non-table rebuilds based on xml schema collection changes - uses the standard dependency list to signal this happening instead
• XML Schema Collections referenced by message types are no longer pulled in when the message type is altered - SQL Server will always accept this change so there's no need to enforce the dependency
• XML Schema Collection dependencies are now treated the same in scripts folders as they are in live databases (avoiding invalid scripts folders where modules depend on old version of XML Schema Collections)

13.6.3.8160 - November 12th 2018

FREQUENT UPDATES RELEASE

Fixes

• SC-9891: History tables aren't shown twice in the SQL View when the Force Column Order option is set
• SC-10283: SQL Compare can distinguish between roles and schemas with the same name when altering permissions
• SC-10285: ADD/DROP HIDDEN clauses in ALTER TABLE ALTER COLUMN statements now parse correctly
• Log missing parents of triggers rather than throwing an exception
• Check that datatypes can cast to each other now takes into account the base type of UDTs

13.6.2.7987 - October 23rd 2018

FREQUENT UPDATES RELEASE

Features

• SC-10215: Add support for sp_tableoption 'large value types out of row'

Fixes

• SDC-2747: When resizing the comparison key window in a mapping dialog, the scrollbar no longer disappears
• SDC-2894: The command line now exits with the correct exit code when the license is invalid
• SC-9126: Permissions are mapped correctly when users are windows principals with differing domains
• SC-10267: The color coding in the single object deployment script window is now aligned correctly

13.6.1.7928 - October 17th 2018

Fixes

• SC-10230 Pressing the "Next" and "Previous" buttons in the SQL diff view will now skip differences in headings
• SC-10234 SQL Compare now supports TRIM functions
• SC-10269 SQL Compare no longer leaves SET statements in a scripts folder when a CLR function has been deleted
• SC-10253, SC-10255, SC-10272: Fixed a performance issue when ignoring NOT FOR REPLICATION

13.6.0.7862 - October 15th 2018

FREQUENT UPDATES RELEASE

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 data deployment