14.10.9.22680 - Dec 8th, 2022

FREQUENT UPDATES RELEASE ### Strapline

Engine API

Features

Fixes

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

14.10.8.22508 - Nov 24th, 2022

Features

• Added new option to ignore STATISTICS_INCREMENTAL during comparison
• Added support for long file paths in windows when enabled in the windows registry (We cannot guarantee how it will work with windows and other applications as it does not seem well supported)

Fixes

• ZD-280144: 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.
• ZD-280317: Fixed missing dll reference that appears when attempting Azure authentication in the command line.

14.10.7.22333 - Nov 15th, 2022

FREQUENT UPDATES RELEASE

Features

• Added new option to ignore statistics incremental during comparison

Fixes

• ZD-280398 - 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.

• ZD-271170 ZD-276218 ZD-278637: Dropping external tables no longer leaves an un-parsable file

14.10.6.22196 - Nov 3rd, 2022

FREQUENT UPDATES RELEASE 

Features

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

Fixes

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

14.10.5.22107 - Oct 18th, 2022

FREQUENT UPDATES RELEASE 

Features

Fixes

• ZD-278733: Prevented the program from failing when encountering ledger tables. Ledger tables are not currently supported but if you would like them to be please log interest on the SQL Compare UserVoice page: https://redgate.uservoice.com/forums/141379-sql-compare

14.10.4.22065 - Oct 11th, 2022

FREQUENT UPDATES RELEASE 

Features

Fixes

• ZD-277198: Fixed missing dll reference that appears when attempting Azure authentication
• ZD-278565: Fixes bug where rebuilding of temporal tables could cause constraint changes in the history table to be duplicated.

14.10.3.21932 - Oct 4th, 2022

FREQUENT UPDATES RELEASE

Features

Fixes

• ZD-277520: Performance focused changes in an indexes registration query

14.10.2.21877 - Sep 28th, 2022

FREQUENT UPDATES RELEASE

Features

Fixes

• ZD-276113: Prevented SQL Compare from creating foreign keys that already exist in target

14.10.1.21845 - Sep 21st, 2022

FREQUENT UPDATES RELEASE

Features

Fixes

• ZD-277111: SQL Snapper - error populating database list when TrustServerCertificate is required to be true is fixed.
• ZD-278020: Fixes command line bug where an invalid filter file would cause SQL Compare to log the error but not stop.

14.10.0.21773 - Sep 13th, 2022

FREQUENT UPDATES RELEASE 

Features

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

Fixes

• ZD-277681: Fixes 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
• ZD-277111 SQL Snapper tool: error populating database list when TrustServerCertificate is required to be true is fixed.