Fixes

• SC-10677: Now avoids stack overflow with heavily nested computed columns more stringently. Some computed columns may show a syntax-only difference between live and scripts databases if they couldn't be parsed; this can be fixed by deploying the live version to the scripts folder.
• SC-10666: The IsSQLCloneDatabase extended property no longer appears in comparisons, so that it can't be accidentally deployed to non-clone databases.
• SC-10682: Sorting the grid by Last Modified date now works correctly.
• SC-10642: When comparing expressions, parser timeouts now cause the comparison to fall back to a raw text comparison instead of throwing an error.

Features

• Enabled sharing of recently used servers with other Redgate products.

Fixes

• SQL Compare no longer drops and recreates foreign key constraints when the only change to the referencing column is its nullability, sparseness, default value, or bound rule.

Fixes

• SC-10056: Server combobox in the live database connection form now correctly updates when clicking the swap sides button.
• SC-10650: When dropping a primary key on a table with disabled non-clustered indexes, SQL Compare now warns you that SQL Server will automatically re-enable the non-clustered indexes.

Fixes

• Mode 80 and 90 databases now act as if they were SQL Server 2008 databases when Use Compatibility Level option is on, and as the underlying server version when it is not.
• SC-10661: Roles and domain users with the same name no longer have their role memberships confused when reading from a scripts folder.
• The order of columns in statistics is now consistently correct.

Fixes

• Command line on Linux now logs to the /logs directory.

Fixes

• SC-10653: Fixed the dialog to select a previous revision when comparing with a SQL Source Control source. Note you need to update SQL Source Control to 7.0.40 or later for this fix to work.

Features

• Server retrieval in connection dialog now retrieves local server instances more comprehensively.

Fixes

• SC-10651: Indexes with changes on temporal tables are no longer dropped twice.

Features

• SQL Compare now supports SQL Server 2019.
• The SQL Compare command line is now available for Linux.

Fixes

• SC-10642 - SQL Compare falls back to not normalising brackets for very large computed columns rather than failing with a parser timeout.