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 now deploy text objects containing line continuations when Add object existence checks is enabled.

Fixes

• SQL Compare no longer uses migration scripts from the Custom Scripts folder when generating a deployment script.

Fixes

• Internal library updated.

Features

• Added support for T-SQL functions CURRENT_TIMEZONE_ID and TRANSLATE.

Fixes

• A foreign key that references the key column(s) of an index will be correctly handled if that index changes in such a way as the only changes are in its non-key columns.
• Query on sys.parameters now runs WITH (NOLOCK).

Features

• Improved warning message when creating users without an associated login.

Fixes

• Add support for T-SQL undocumented virtual column %%lockres%%.
• More queries now run WITH (NOLOCK).

Fixes

• Fixed parsing of file paths in bulk insert statements.

Features

• To support automation environments, the command line now has an /allUsers flag that can be used when activating to allow it to be used by all users, including service accounts.

Fixes

• Internal library updated.

Fixes

• Fixed object reference error in SQL Snapper when attempting to create a database snapshot.

Fixes

• Fixed support for SQL Server 2019 differential backups.

Fixes

• Fixed issue of usages of AT TIME ZONE leading to comparison differences which do not change the function of scripts, but which do not go away after deployment.
• Fixed queries to use WITH (NOLOCK) consistently when reading database schema.

Fixes

• Fixed text diff view when an extended property is added or removed in the middle.
• Fixed null reference error when deploying from a snapshot file.
• Fixed issue in the project settings dialog where the username for a database using Active Directory universal with MFA auth could get copied over the other database's username.

Fixes

• Fixed parsing error involving schema-qualified DATA values in the PREDICT operator.
• Fixed issue with modal windows not appearing on expected monitor.
• Fixed deployment order of user-defined types when deploying from a snapshot.

Fixes

• Changes to role owners now get applied to scripts folders.
• Fixed failing deployment script when dropping a function that is referred to by a constraint.
• Fixed a crash when loading a snapshot containing several external tables with the same name.

Fixes

• Fixed support for clustered columnstore indexes in scripts folders where sp_autostats has been set to OFF.

Fixes

• Fixed Active Directory universal with MFA authentication.

Fixes

• Fixed parsing of unicode strings in search properties and aliases.

Fixes

• Internal library updated.

Fixes

• Internal library updated.