13.3.8.6436 - June 11th 2018

Compatibility with SQL Data Compare 13.3.8.6436

13.3.7.6422 - June 11th 2018

FREQUENT UPDATES RELEASE

Features

• The old Interactive HTML report type has been reinstated as the Classic HTML report type

Fixes

• SC-10089: Deploying column changes to a fulltext index in a scripts folder will no longer create duplicate ALTER FULLTEXT INDEX statements
• SC-10100: Permissions on history tables are now registered correctly
• SC-10104: Modifying a key index of a fulltext index will now drop the fulltext index before and recreate it later

13.3.6.6375 - June 4th 2018

FREQUENT UPDATES RELEASE

Fixes

• SC-2813: CLR triggers will now be deployed if an assembly they require is rebuilt and Include Dependencies is on, even if their parent object is not selected, which avoids the deployment failing due to target CLR triggers that are no longer valid.
• SC-9791: The 'DROP and CREATE instead of ALTER' option is no longer ignored when creating a deployment script.
• SC-10050: Fixes crash when trying to deploy a Service that references a system-defined Contract
• SC-10077: Multi-line string literals now have difference highlighting applied correctly
• SC-10083: Adding a check constraint while rebuilding a table no longer causes an invalid deployment script
• SC-10086: Functions that are schema bound and omit 'AS' in their definition no longer cause an invalid deployment script
• SC-10095: Removing a column from a fulltext index on a view will now be flagged as a difference
• SC-10099: Altering the columns in a fulltext index on a view now produces a correct deployment script
• CLR triggers are now replaced when they need to be dropped to enable assembly rebuild.
• UDT changes in script folders now cause objects using the UDT to be deployed as dependencies, to ensure the script folder does not become inconsistent.
• UDTs no longer create objects that depend on the type as dependencies when you attempt to deploy just the type (they will still pull differences in objects that exist on both sides).

13.3.5.6244 - May 23rd 2018

Features

• SQL Compare supports external language event types, which are now available on Azure

Fixes

• Telemetry has been updated in accordance with the privacy policy available at https://www.red-gate.com/website/legal

13.3.4.6198 - May 17th 2018

FREQUENT UPDATES RELEASE

Fixes

• SC-10080: SQL Compare again ignores line endings whitespace in string literals when IgnoreWhiteSpace switched on.
• SC-10050: SQL Compare can again handle Services with Contract dependencies not in the database that could just be arbitrary strings (e.g. as in the case with Query Notifications)
• IgnoreUsers now properly ignores role memberships again; role memberships are no longer ignored when IgnoreUsers is off
• Extended properties on queue event notifications are no longer deployed when the IgnoreEventNotificationsOnQueues option is on
• SC-10025: SQL Compare more gracefully handles errors with missing schemas in a scripts folder
• SC-9713: Using the IncludeIdentical switch on the command line no longer rebuilds objects with default non_PRIMARY filegroups
• SC-10044: The existence of multiple DDL event types on the server that are unknown to SQL Compare will no longer cause trigger registration to fail
• SC-10061: Double-clicking on a project in the 'My projects' screen now does 'Compare now' instead of 'Edit project'
• SC-10062: Command line can deploy static data from a table with a primary key and unique index to a table with only a unique index
• SC-10072: Simple HTML option description removed from help widget in Generate Comparison Results Report dialog
• SC-10074: When rebuilding a temporal table, data from the GENERATED ALWAYS AS ROW START/END columns is now preserved
• SC-10077: When using "Ignore white space" option, nested string literals with whitespace differences now have highlighting applied

13.3.3.6037 - May 1st 2018

FREQUENT UPDATES RELEASE

Fixes

• SC-10054: SQL Compare more gracefully handles errors with missing schemas in a scripts folder
• SC-10051: SQL Compare IgnoreFullTextIndexing option works as expected when NoTransactions switch on
• SC-10057: Command line no longer fails in certain scenarios when the /exclude switch is used with /include:identical

13.3.2.5875 - April 17th 2018

Features

• SC-10044: SQL Compare now handles ADD_SENSITIVITY_CLASSIFICATION and DROP_SENSITIVITY_CLASSIFICATION event types

Fixes

• SC-10036: The SQL Compare command line will no longer fail when there is whitespace between options in an XML argument file

• SC-10014: SQL Compare now re-creates target performance indexes that had to be dropped for table changes when Ignore Performance Indexes option is on

• SC-10018: SQL Compare no longer tries to add constraints to a temporal table's history table.

13.3.1.5775 - April 9th 2018

FREQUENT UPDATES RELEASE

Features

• SQL Compare command line now includes switches /activedirectory1 and /activedirectory2 to specify the use of Azure Active Directory authentication

Fixes

• SC-10022: SQL Compare no longer fails when deploying a filter predicate in a security policy where the number of arguments has changed

13.3.0.5760 - April 4th 2018

FREQUENT UPDATES RELEASE

Features

• SC-9967: "Ignore whitespace" option is no longer applied to string literals

Fixes

• SC-10019: /exclude command line switch now correctly overrides /include:Identical in generated reports
• SC-10016: Fixed a bug where fulltext indexes on views with STOPLIST = OFF were incorrectly registered from live databases
• SC-9912: SQL Compare no longer crashes when scripting out a trigger it can't parse
• Event notifications now select the Service that they're on as a dependency, if it's in the source database and IncludeDependencies is enabled
• SC-9948 Comparisons for a stoplist with NULL owner no longer crash