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.

Fixes

• Internal library updates.

Fixes

• Integer scale arguments for time data type columns, in scripts folders, outside the integer range of 0 to 7 will be read as the default scale value of 7 not 1.
• Fixed error message for untrusted certificates.

Features

• SQL Compare now encrypts connections to Microsoft SQL Server by default. Previously, connections would have been encrypted according to the server's Force Encryption setting.
• Setting an Application ID is no longer needed to connect using Microsoft Azure Active Directory Universal with MFA authentication.
• Linux command line timebomb has been doubled to 180 days.

Fixes

• Fixed the reading of scale arguments for time, datetime2 and datetimeoffset types in scripts folder user defined type creation statements.