Fixes

• Update to licensing link in CLI output.

Fixes

• Fixed error when changing a history table clustered index to a clustered columnstore index.
• Fixed an issue encountered when SQL Server system defined CLR types are prefixed with "[sys].".

Features

• Added a link to licensing restrictions documentation in CLI output header.

Features

• Compatibility with SQL Data Compare 15.0.13.23797.

Fixes

• Fixed an issue in the command line where options such as "TrustServerCertificate" in the server switches were not being used.

Features

• Added initial level of support for the use of the WINDOW clause in SELECT statements.

Fixes

• Fixed column rename bug.

Fixes

• Fixed parsing error when property...

Fixes

• Adding 'NOT NULL' to a temporal table column will now update values in the history table to the default value and display a warning.
• Primary keys are now correctly dropped before being replaced when using system versioning.

Features

• Added support for long file paths in Microsoft Windows when enabled in the Windows registry.

Fixes

• SCHEMABINDING is correctly dropped on functions that are created WITH EXECUTE AS...

Features

• Added support for the 'OPTIMIZE_FOR_SEQUENTIAL_KEY' index option.

Fixes

• Fixed an issue in parsing query MATCH syntax from scripts folders.

Features

• Upgraded to Microsoft.Data.SqlClient 5.0.0.

Fixes

• Fixed an issue where database connections failed due to mishandling of the Failover Partner parameter.

Fixes

• SQL Compare will now only rebuild a table...

Features

• Added support for T-SQL undocumented virtual column '%%physloc%%'.

Fixes

• Fixed deployment script object existence checks, when source and target have column names that differ only in case.

Features

• Updated compatibility with SQL Data Compare 14.8.4.21440.

Fixes

• Fixed an issue with verifying server certificates when an explicit port number is set.

Features

• Internal library updates.

Features

• Added the option to use 'CREATE OR ALTER' statements when deploying to servers that support this feature.

Fixes

• Fixed an issue with recognising the data type of fields that are user defined types, in history tables of temporal tables.

Features

• Updated compatibility with SQL Data Compare 14.7.6.21017.

Fixes

• Fixed an...

Fixes

• Delimit credential names for external data sources.

Fixes

• Fixed issue which caused data compression settings on partitioned temporal tables to not be read from scripts folders.

Fixes

• Stop rebuilding temporal tables and their history tables due to system named constraint and index name differences when the option "Ignore system named constraint and index names" is used.
• SQL Compare can...