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 ..., SCHEMABINDING options, when required to do so by a change to an underlying object.
• Fixed missing DLL reference that appears when attempting Azure authentication in the command line.

Features

• Added a new option to ignore 'statistics_incremental' during comparison.

Fixes

• Saving a deployment script to a non-default location via the small "save script" button in the deployment wizard no longer causes the default location in global application settings to change.
• Dropping external tables no longer leaves an un-parsable file.

Features

• Improved scripts folder file name generation in the case of long paths or file names.

Fixes

• SQL Compare will no longer install the Microsoft Active Directory Authentication Library (ADAL) as a pre-requisite as it is superseded by MSAL.

Fixes

• Prevented the program from failing when encountering ledger tables.

Fixes

• Fixed missing DLL reference that appears when attempting Azure authentication.
• Fixed bug where rebuilding of temporal tables could cause constraint changes in the history table to be duplicated.

Features

• Performance focused changes in a indexes registration query.

Fixes

• Prevented SQL Compare from creating foreign keys that already exist in target.

Fixes

• SQL Snapper - Error populating database list when TrustServerCertificate is required to be true has been fixed.
• Fixed command line bug where an invalid filter file would cause SQL Compare to log the error but not stop.

Features

• Beta support for Microsoft SQL Server 2022 Preview. New SQL 2022 features may not function properly.

Fixes

• Fixed scripts folder parsing of the character pair "<-" whether they appear in a MATCH graph search pattern or as a Less Than comparison operator followed by a unary negative operator.
• SQL Snapper tool: Error populating database list when TrustServerCertificate is required to be true has been fixed.