16.0.16.28949 - 21 May 2026

FREQUENT UPDATES RELEASE

Bug fix

• Fixed an issue when encountering columns with defaults that use SQL Server functions that don’t have trailing parenthesis e.g. current_date
• Fixed a PlatformNotSupportedException when generating Classic HTML or Excel reports from the CLI

16.0.15.28900 - 12 May 2026

FREQUENT UPDATES RELEASE

New feature

• Support for JSON_QUERY WITH ARRAY WRAPPER introduced in SQL Server 2025

16.0.14.28844 - 05 May 2026

Bug fix

• ZD-355966: The Edit Filter Rules dialog now adds nested AND/OR clauses correctly.
• ZD-355509: Added support for SET TEXTSIZE -1 in stored procedure bodies.

Breaking change

• The Docker image base has changed from Ubuntu Noble to Alpine 3.23. If you use this image as a base for your own Dockerfile, you will need to update it to use Alpine-compatible commands (e.g. apk add instead of apt-get install).

Improvement

• The Docker image base has been updated from Ubuntu Noble to Alpine 3.23, reducing image size and resolving security vulnerabilities in the base OS.

16.0.13.28757 - 21 April 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-354140: Ignore Collations option now works for memory-optimised tables on SQL Server 2016+

Feature

• Support for the CURRENT_DATE keyword introduced in SQL Server 2025
• Support for JSON_ARRAYAGG and JSON_OBJECTAGG aggregate functions introduced in SQL Server 2025

16.0.12.28712 - 14 April 2026

16.0.11.28694 - 08 April 2026

FREQUENT UPDATES RELEASE

Engine API

• Modernized engine progress tracking

Bug fix

• ZD-352570: Fixed a case where PERIOD FROM SYSTEM TIME is added between an existing column and a new one
• ZD-353428: Fixed an issue where function dependencies on tables might not be recognized correctly if a user-defined table type existed with the same name as the table.

16.0.10.28672 - 31 March 2026

FREQUENT UPDATES RELEASE

Feature

• Support for ORDER clause on clustered and non-clustered columnstore indexes

16.0.9.28654 - 24 March 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-351864: Fixed Null Reference exception when deploying a data type change to XML column

16.0.8.28634 - 17 March 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-346605: Memory optimized tables with replaced indexes are now correctly modelled

16.0.7.28607 - 04 March 2026

FREQUENT UPDATES RELEASE

16.0.6.28582 - 24 February 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-350862: Fixed an issue where SQL Compare would fail to handle CREATE EXTERNAL MODEL syntax in stored procedure or function bodies.

16.0.5.28494 - 28 January 2026

16.0.4.28477 - 20 January 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-347175: Many more system function names are now correctly recognized.
• Fixed offline licensing workflow for SQL Compare docker container

16.0.3.28451 - 14 January 2026

FREQUENT UPDATES RELEASE

Bug fix

• Improved error message for certain invalid filter files
• ZD-339523: Database collation is now written to snapshots
• ZD346735: Fixed a connection issue in SQL Snapper where “Encrypt” option was incorrectly set to True when the checkbox was unchecked.

Feature

• Support for || string concatenation operator introduced in SQL Server 2025

16.0.2.28399 - 06 January 2026

FREQUENT UPDATES RELEASE

16.0.1.28365 - 19 December 2025

FREQUENT UPDATES RELEASE

New feature

• Use Distroless base image for Sql Compare docker image to reduce image size and improve security.

Bug fix

• ZD-335843: Fix issue where USING locale was not included for PARSE and TRY_PARSE functions

Improvement

• Add the name of the file where a parsing error occurs into the error message

16.0.0.28327 - 11 December 2025

Breaking change

• Remove support for storing passwords in the project file and instead store these passwords in the Windows Credential Manager.

15.4.29.28207 - 04 December 2025

New feature

• Preview feature: Support Redgate Data Modeler models as a comparison source.

15.4.28.28077 - 14 November 2025

FREQUENT UPDATES RELEASE

Features

• Support for SQL Server 2025. New SQL Server 2025 features may not function correctly.

Fixes

• Fixed an issue where the ‘Create snapshot of target before deployment’ option was not generating a snapshot

15.4.27.28006 - 04 November 2025

FREQUENT UPDATES RELEASE

Features

• Added support for SSMS 21 as an external SQL Editor

15.4.26.27858 - 02 October 2025

FREQUENT UPDATES RELEASE

Fixes

• ZD-329373: Use sp_rename instead of dropping and recreating columns when collations are different
• Fixes incorrect exit code being returned when a licensing error occurs

15.4.25.29287 - 18 September 2025

FREQUENT UPDATES RELEASE

15.4.24.29094 - 02 September 2025

FREQUENT UPDATES RELEASE

15.4.23.28990 - 20 August 2025

15.4.22.28888 - 11 August 2025

FREQUENT UPDATES RELEASE

15.4.21.28685 - 15 July 2025

FREQUENT UPDATES RELEASE

15.4.20.28553 - 17 June 2025

Fixes

• ZD-333542: Fixed an issue preventing project files from loading when they used a legacy authentication method.

15.4.19.28507 - 12 June 2025

FREQUENT UPDATES RELEASE

15.4.18.28452 - 03 June 2025

FREQUENT UPDATES RELEASE

15.4.17.28422 - 29 May 2025

15.4.16.28371 - May 12th, 2025

FREQUENT UPDATES RELEASE

Fixes

• ZD-330789: Allow for comparison of user-defined functions named ‘try_cast’ in scripts folders

15.4.15.28277 - Apr 16th, 2025

FREQUENT UPDATES RELEASE

Fixes

• Updated authentication type labels for Azure Active Directory to Microsoft Entra in the UI

15.4.14.28133 - Mar 25th, 2025

FREQUENT UPDATES RELEASE

15.4.13.28096 - Mar 13th, 2025

FREQUENT UPDATES RELEASE

15.4.12.28089 - Mar 6th, 2025

FREQUENT UPDATES RELEASE

Fixes

• ZD326791: Added support for included columns on inline indexes

15.4.11.28054 - Feb 24th, 2025

FREQUENT UPDATES RELEASE

Fixes

• Add support for IGNORE NULLS, RESPECT NULLS on the LAG and LEAD functions

15.4.10.27977 - Feb 6th, 2025

FREQUENT UPDATES RELEASE

Fixes

• ZD-324430: Add support for Delta external file format.

15.4.9.27950 - Jan 31st, 2025

FREQUENT UPDATES RELEASE

Fixes

• ZD-324963: Fixed the issue when trying to write to a read only file/folder.
• ZD-325187: Add support for SQL Server 2022 SSDT projects.

15.4.8.27875 - Jan 22nd, 2025

FREQUENT UPDATES RELEASE

15.4.7.27827 - Jan 14th, 2025

FREQUENT UPDATES RELEASE

15.4.6.27751 - Dec 19th, 2024

FREQUENT UPDATES RELEASE

Engine API

• SqlCompareExceptions now provide unredacted Message and ToString() values.

Fixes

• Fix string.Format call in Message.Text

15.4.5.27738 - Dec 17th, 2024

FREQUENT UPDATES RELEASE

Fixes

• ZD-320234: Fixed the issue where ONLINE=ON was being added when altering a column on a temporal table

15.4.4.27680 - Dec 10th, 2024

FREQUENT UPDATES RELEASE

15.4.3.27665 - Dec 3rd, 2024

Fixes

• Removed the Flyway option from the project dialog, as it had very low usage

15.4.2.27580 - Nov 22nd, 2024

Features

• Updates the licensing client

Fixes

• Allows tool to be used across user profiles on the same machine
• Prioritises licenses correctly
• ZD-321309: Fixed a dependency error with ‘System.Memory’ when selecting a database in SQL Snapper

15.4.1.27450 - Nov 12th, 2024

Engine API

• MessageBase has been inlined into Message, which is now a record.

Fixes

• Ensures the user has verified their email address as part of the login flow

15.4.0.27425 - Nov 11th, 2024

FREQUENT UPDATES RELEASE

Features

• Updated licensing with improved UI, integration, security, and trials. Read more at https://www.red-gate.com/blog/redgate-licensing-update
• Serial Keys have been retired.

15.3.14.27393 - Nov 5th, 2024

Fixes

• Fixed issue when displaying error messages
• Fixed a crash when using newer versions of SQL Prompt formatting

15.3.13.27313 - Oct 24th, 2024

FREQUENT UPDATES RELEASE

15.3.12.27264 - Oct 15th, 2024

FREQUENT UPDATES RELEASE

Engine API

• SQL Compare Engine no longer has a dependeny on Microsoft.Data.SqlClient. You may need to add this package to your project if you are using the SQL Compare Engine NuGet package.
• Removed methods marked as Obsolete on public API that depended on Microsoft.Data.SqlClient.
• Removed .SSMS and .SSMS20 versions of the SQL Compare Engine NuGet package.

Fixes

• ZD-304828: Add support for ignore nulls, respect nulls options on the last_value function

15.3.11.27029 - Sep 17th, 2024

FREQUENT UPDATES RELEASE

Fixes

• ZD-302580: Fixed the issue where ONLINE=ON was being specified within an ALTER statement for the primary index of a table containing a spatial data type column, and for the creation of spatial indexes
• ZD-304828: Add support for ignore nulls, respect nulls options on the first_value function

15.3.10.26944 - Sep 12th, 2024

FREQUENT UPDATES RELEASE

Engine API

• Marked a number of public API methods as obsolete. They will be removed in a future release. All methods have have replacements that should be used instead, see the warning message for guidance.

Fixes

• Stability improvements for the UI

15.3.9.26398 - Jul 31st, 2024

FREQUENT UPDATES RELEASE

Fixes

• ZD-314973, ZD-302580: Fixed the issue where ONLINE=ON was being specified within an inlined primary index of a temporal table within a CREATE Table statement

15.3.8.26171 - Jul 16th, 2024

FREQUENT UPDATES RELEASE

Fixes

• Changed the name of sqlcompare.tar.gz to include the version number

15.3.7.25849 - Jun 4th, 2024

FREQUENT UPDATES RELEASE

Fixes

• ZD-308580: Add support for security policy schema binding

15.3.6.25729 - May 8th, 2024

Fixes

• ZD309124: Prevent unwanted multiple space characters appearing in CREATE OR ALTER statements

15.3.5.25572 - Apr 9th, 2024

FREQUENT UPDATES RELEASE

Fixes

• ZD304081: SQL Compare no longer locks the selective_xml_index_paths catalog view during registration.

15.3.4.25528 - Mar 26th, 2024

FREQUENT UPDATES RELEASE

Fixes

• ZD-307150: Fixed issue when connecting to Azure SQL instance where an error occurred related to the loading of assembly Microsoft.IdentityModel.Abstractions
• Additional connection string properties added to the server name are now used again when comparing two SQL Source Control revisions from the SQL Compare command line

15.3.3.25341 - Feb 27th, 2024

FREQUENT UPDATES RELEASE

Fixes

ZD-304889, ZD-305852, ZD-304880: Fixed scripts folder parsing of “window” when not used as a keyword

15.3.2.25249 - Feb 15th, 2024

FREQUENT UPDATES RELEASE

Engine API

• Upgraded to Microsoft.Data.SqlClient 5.1.5

Fixes

ZD-305767: Ensure rendering of the pre and post scripts in the summary view does not break the UI

15.3.1.25177 - Feb 6th, 2024

FREQUENT UPDATES RELEASE

Features

• ZD-298420: Add support for the TRIM function optional arguments LEADING, TRAILING and BOTH
• ZD-303715: Fixed a crash when permissions are added to columns of a file table
• ZD-304545: Added support for using sp_unbindefault against a table to override the binding of a default on a column’s user-defined type.

Fixes

• ZD-303860: Fixed an issue where some temporary files were not being deleted when generating a snapshot

15.3.0.25068 - Jan 12th, 2024

Engine API

• Upgraded to Microsoft.Data.SqlClient 5.1.4

Features

• Added read-only support for Flyway projects, allowing you perform comparisons with Flyway on the left.

Fixes

• ZD-302580: Prevent scripting Online = On for indexes which are part of a UDT Table

15.2.7.24880 - Dec 27th, 2023

FREQUENT UPDATES RELEASE

Fixes

• ZD-303915: Fixed a caching bug during script folder registration.

15.2.6.24771 - Dec 12th, 2023

FREQUENT UPDATES RELEASE

Features

• ZD-302367: Changes UI to always open ‘Save As’ dialog window when saving filters.

15.2.5.24669 - Dec 5th, 2023

FREQUENT UPDATES RELEASE

Features

• ZD-299431: Slightly reduced memory usage of the UI and engine.
• ZD-299431: Deployment script syntax highlighting is now disabled for scripts exceeding 300k lines for performance reasons.
• Speed up script folder registration.
• ZD-294122: Add support for APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC functions in SQL Server 2022.

Fixes

• ZD-299431: Fixed a memory leak in the SQL Compare UI, noticeable when refreshing large comparisons.
• ZD-299431: Fixed a crash on the pre-deploy Summary tab when toggling the grouping for large deploys.
• ZD-302521, ZD-302326, ZD-280962, ZD-262990, ZD-297151 & ZD-284803: Stopped scripts folders containing a function with the INLINE option erroring and added a warning when attempting to deploy them to unsupported server versions

15.2.4.24551 - Nov 28th, 2023

FREQUENT UPDATES RELEASE

Features

• ZD-298714: When altering a column or index, better detection of when ONLINE = ON cannot be used
• ZD-299431: Sped up dependencies selection screen by tweaking column autosizing.
• ZD-299431: Sped up dependency resolution for SQL Compare GUI and CLI.
• ZD-299431: Sped up deploy summary tab.
• ZD-299431: Sped up snapshot registration when triggers are present.

15.2.3.24503 - Nov 21st, 2023

FREQUENT UPDATES RELEASE

Features

• Add support for the JSON_OBJECT function introduced in SQL Server 2022

15.2.2.24260 - Nov 7th, 2023

FREQUENT UPDATES RELEASE

15.2.1.24235 - Oct 31st, 2023

Engine API

• RedGate.SQLCompare.Engine.Difference now has a subclass RedGate.SQLCompare.Engine.DifferenceSubtypes.ViewTableDifference. This subclass has an extra property ContainsFullTextIndexChanges.

15.2.0.24040 - Oct 6th, 2023

FREQUENT UPDATES RELEASE

Features

• ZD-297510: Made the table mapping screens more responsive by significantly reducing the number of times they reprocess saved data.
  • Note that the project Save button no longer grays out when there are no unsaved changes.

15.1.2.24012 - Sep 28th, 2023

FREQUENT UPDATES RELEASE

Fixes

• Update to licencing link in CLI output

15.1.1.23971 - Sep 20th, 2023

FREQUENT UPDATES RELEASE

Fixes

• ZD-297062: Fixes error when changing a history table clustered index to a clustered columnstore index.
• ZD-290609: Fixes an issue encountered when SQL Server system defined CLR types are prefixed with “[sys].”

15.1.0.23826 - 06 September 2023

Engine API

• Added link to licensing restrictions documentation in CLI output header
• Fixed an issue where the invalid object detection would flag objects as invalid if they have a reference to an external DB.

15.0.13.23797 - 29 August 2023

15.0.12.23728 - Aug 9th, 2023

FREQUENT UPDATES RELEASE

Fixes

• Fixed column rename bug

15.0.11.23723 - 08 August 2023

Features

• ZD-287143: Add initial level of support for the use of the WINDOW clause in SELECT statements

Fixes

• ZD-285053: Fixes an issue in the command line where options such as “TrustServerCertificate” in the server switches were not being used

15.0.10.23691 - Aug 1st, 2023

FREQUENT UPDATES RELEASE

Fixes

• ZD-293296: Fix parsing error when property access is made on CLR types returned from CASE Statements.

15.0.9.23488 - May 30th, 2023

Fixes

• ZD-292465: Added SSMS19 to list of SQL editor options

15.0.8.23473 - May 23rd, 2023

FREQUENT UPDATES RELEASE

Engine API

• Upgraded to Microsoft.Data.SqlClient 5.1.1

Features

• ZD-290643: Stopped changes to external tables causing script file name changes

15.0.7.23280 - Mar 14th, 2023

FREQUENT UPDATES RELEASE

Fixes

• “Encrypt” and “Trust server certificate” server connection checkbox values are now loaded with server connection details from server dropdown

15.0.6.23274 - Mar 7th, 2023

FREQUENT UPDATES RELEASE

Fixes

• ZD-286622: Warn that non-primary filestream filegroups of tables will need to be created manually

15.0.5.23181 - Feb 21st, 2023

FREQUENT UPDATES RELEASE

Fixes

• ZD-285412: Fixed issue with table mappings not appearing when connecting through Azure MFA to a managed instance

15.0.4.23133 - Feb 14th, 2023

FREQUENT UPDATES RELEASE

Fixes

• Added warning to command line clarifying which differences will be deployed

15.0.3.23021 - Jan 24th, 2023

FREQUENT UPDATES RELEASE

Fixes

• ZD-284359: Added missing schema check in a column existence test

15.0.2.22953 - Jan 17th, 2023

Features

• ZD-282763 “Encrypt” and “Trust Server Certificate” can now be specified on database connections with checkboxes, rather than the workround of manually appending connection string parameters to the server name

Fixes

• Fixed minor bugs relating to the handling of long file paths

15.0.1.22876 - Jan 11th, 2023

FREQUENT UPDATES RELEASE

Features

• ZD-283578: Added “Dynamically override default save location when saving to a new location in the deployment script save dialog” option to application settings.

15.0.0.22793 - Dec 20th, 2022

FREQUENT UPDATES RELEASE

Features

• SQL Server 2022 support
• UI displays a warning that support for SQL Server 2008 and SQL Server 2008R2 will be removed in a future version
• UI displays a warning when an unsupported scripts folder is selected

14.10.9.22680 - Dec 8th, 2022

FREQUENT UPDATES RELEASE

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

FREQUENT UPDATES RELEASE

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

• ZD278637 - Dropping external tables no longer leaves an un-parsable file
• 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

Fixes

• ZD278733: 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

Engine API

• Upgraded to Microsoft.Data.SqlClient 5.0.1

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

Fixes

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

14.10.2.21877 - Sep 28th, 2022

FREQUENT UPDATES RELEASE

Fixes

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

14.10.1.21845 - Sep 21st, 2022

FREQUENT UPDATES RELEASE

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.

14.9.3.21711 - Sep 6th, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-276627: Added support for the OPTIMIZE_FOR_SEQUENTIAL_KEY index option.

14.9.2.21665 - Aug 30th, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-274687 Fixes an issue in parsing query MATCH syntax from scripts folders

14.9.1.21642 - Aug 16th, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-274277 Fixed an issue where database connections failed due to mishandling of the Failover Partner parameter.

14.9.0.21563 - Aug 10th, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD269834 SQL Compare will now only rebuild a table when the filegroup differs just by casing if the “Use case-sensitive object definition” comparison option is on

14.8.5.21499 - Jul 26th, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-275263: Add support for T-SQL undocumented virtual column %%physloc%%
• ZD-275762: Fix deployment script object existince checks, when source and target have column names that differ only in case.

14.8.4.21440 - Jul 19th, 2022

FREQUENT UPDATES RELEASE

14.8.3.21395 - Jul 5th, 2022

FREQUENT UPDATES RELEASE

Fixes

• Fixes an issue with verifying server certificates when an explicit port number is set.

14.8.2.21320 - Jun 28th, 2022

FREQUENT UPDATES RELEASE

14.8.1.21249 - Jun 22nd, 2022

FREQUENT UPDATES RELEASE

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

14.8.0.21190 - Jun 14th, 2022

FREQUENT UPDATES RELEASE

Strapline

30 - SQL Server connections encrypted by default 20 - Application ID no longer required for Azure Universal Auth

Engine API

• Upgraded to Microsoft.Data.SqlClient 4.1.0

Features

• SQL Compare now encrypts connections to 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 Azure Active Directory Universal with MFA authentication
• Linux command line timebomb doubled to 180 days

Fixes

• ZD-259302 ZD-273613: Fixed the reading of scale arguments for time, datetime2 and datetimeoffset types in scripts folder user defined type creation statements

14.7.8.21163 - Jun 8th, 2022

14.7.7.21053 - May 24th, 2022

FREQUENT UPDATES RELEASE

Features

• Option added to use CREATE OR ALTER statememnts when deploying to servers that support this feature

Fixes

• ZD-271345: Fixed an issue with recognising the data type of fields that are user defined types, in history tables of temporal tables

14.7.6.21017 - May 17th, 2022

FREQUENT UPDATES RELEASE

14.7.5.20971 - Apr 26th, 2022

FREQUENT UPDATES RELEASE

14.7.4.20967 - Apr 25th, 2022

FREQUENT UPDATES RELEASE

14.7.3.20962 - Apr 21st, 2022

FREQUENT UPDATES RELEASE

14.7.2.20940 - Apr 7th, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-269731: Fixed an issue where the Line Differences view shows a message about an incorrect license
• ZD-268685: When FIPS is enabled, encrypted objects are now correctly decrypted, when the option to do so is set

14.7.1.20862 - Mar 22nd, 2022

FREQUENT UPDATES RELEASE

Features

• Add support for additional T-SQL built-in functions

14.7.0.20823 - Mar 16th, 2022

FREQUENT UPDATES RELEASE

Strapline

20 - SQL Prompt formatted diff view

Engine API

• New options SchemaExistenceChecks, RoleExistenceChecks added to API.

Features

• Added a SQL Prompt formatted diff view, using the current SQL Prompt formatting options. Requires SQL Prompt v10.11.5 or above. (SQL Toolbelt or SQL Toolbelt Essentials license required)

14.6.20.20708 - Mar 1st, 2022

FREQUENT UPDATES RELEASE

Fixes

• Delimit credential names for external data sources

14.6.19.20650 - Feb 22nd, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-256556: Fixed issue which caused data compression settings on partitioned temporal tables to not be read from scripts folders

14.6.18.20606 - Feb 15th, 2022

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-264118: 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
• ZD-264035: SQL Compare can now deploy text objects containing line continuations when Add object existence checks is enabled

14.6.17.20533 - February 3rd 2022

FREQUENT UPDATES RELEASE

Features

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

14.6.16.20465 - January 25th 2022

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

ZD-263126: Include related T-SQL variable declaration and assignment statements in the serialization of extended properties

14.6.15.20403 - January 12th 2022

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-261847: Add support for T-SQL functions CURRENT_TIMEZONE_ID and TRANSLATE
• ZD-263527: 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
• ZD-260221 Query on sys.parameters now runs WITH (NOLOCK)

14.6.14.20342 - December 22nd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• Improved warning message when creating users without an associated login

Fixes

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

14.6.13.20238 - December 8th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-262649: Fixed parsing of file paths in bulk insert statements

14.6.12.20158 - November 29th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

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

14.6.11.20142 - November 22nd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

ZD-259045: Fix issue where ALTER TABLE SET statements were not being included in serialization of tables.

14.6.10.20102 - November 10th 2021

Strapline

10 - Bug fixes

Fixes

• ZD-260283: Fix object reference error in SQL Snapper when attempting to create a database snapshot

14.6.9.20059 - November 1st 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-261137: Support for SQL Server 2019 differential backups fixed

14.6.8.20031 - October 26th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-256677: Fix 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.
• ZD-260222: Fix queries to use WITH (NOLOCK) consistently when reading database schema

14.6.7.20011 - October 18th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD256971: Fix text diff view when an extended property is added or removed in the middle
• ER-57: Fix null reference error when deploying from a snapshot file.
• ZD259357: 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

14.6.6.19949 - October 5th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

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

14.6.5.19910 - September 27th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-257212: Changes to role owners now get applied to scripts folders.
• ZD-254395: Fix to failing deployment script when dropping a function that is referred to by a constraint.
• SC-11006, ER-55: Fixed a crash when loading a snapshot containing several external tables with the same name

14.6.4.19846 - September 20th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD256698: Support for clustered columnstore indexes in scripts folders where sp_autostats has been set to OFF

14.6.3.19802 - September 16th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Upgraded to Microsoft.Data.SqlClient v3

Fixes

• Fixed Active Directory universal with MFA authentication

14.6.2.19746 - September 13th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Fixed parsing of unicode strings in search properties and aliases

14.6.1.19650 - September 6th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.6.0.19635 - August 19th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.22.19589 - August 16th 2021

Strapline

10 - Bug fixes

Fixes

• ZD-254361: Fixed broken table renaming technique.

14.5.21.19562 - August 9th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• When the RG_SC_CREATE_OR_ALTER environment variable is non-empty, SQL Compare Engine will script out text objects using the CREATE OR ALTER syntax for SQL Server versions that support it.

14.5.20.19533 - August 2nd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.19.19515 - July 26th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• Improved performance of reading from backup files

14.5.18.19506 - July 22nd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-254361: Fixed error ‘field change calculation failed in TableRebuildChecker’ when deploying in certain mapping scenarios.

14.5.17.19461 - July 19th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.16.19388 - July 12th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.15.19373 - July 5th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• Changed default deployment script encoding to UTF-8

14.5.14.19355 - June 30th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.13.19322 - June 23rd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.12.19294 - June 15th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.11.19213 - June 7th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.10.19206 - June 2nd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-250030: Turning off system versioning on a table that is consumed by a security policy no longer results in an incorrect deployment script
• ZD-251196: Fixed a bug in deployment scripts using CURRENT_USER
• ZD-251135: STATISTICS_NORECOMPUTE=ON is no longer scripted out for columnstore indexes; instead sp.autostats is invoked

14.5.9.19133 - May 24th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Fixed help menu link

14.5.8.19095 - May 19th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Updated incorrect warning about in-memory tables in Azure SQL Databases.

14.5.7.19065 - May 11th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.6.18966 - May 5th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.5.5.18909 - April 27th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-248719: Parser messages are now propagated to command-line output.

14.5.4.18843 - April 19th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Updated to Newtonsoft.Json 13

14.5.3.18766 - April 12th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Internal

• Exception reports now go to Application Insights instead of Raygun

14.5.2.18630 - March 23rd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Register and CreateEmptyTarget methods have been moved from IDatabase to DatabaseFactory

Fixes

• ZD-245196: Comparing a scripts folder with invalid static data now results in an error.

14.5.1.18536 - March 15th 2021

Strapline

10 - Bug fixes

Fixes

• SC-10973: The create scripts folder dialog no longer causes the UI to hang.

14.5.0.18430 - March 4th 2021

FREQUENT UPDATES RELEASE

Strapline

20 - PolyBase support

Features

• SQL Compare now supports PolyBase objects (external data source, external file format and external table)

Fixes

• The create database dialog no longer fails when using SQL Server on Linux

14.4.23.18321 - February 22nd 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-245196: Deploying a full text catalog along with its owner will no longer duplicate the CREATE USER statement
• SC-10963: The /makescripts option on the command line no longer writes out migration blocks metadata for non-migration blocks databases

14.4.22.18256 - February 15th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10959: SQL Compare now properly handles temporal tables on partition schemes

14.4.21.18202 - February 8th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.20.18129 - February 1st 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.19.18070 - January 25th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.18.17935 - January 18th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10308: Renaming a column included in a temporal table primary key will no longer produce an invalid deployment script

14.4.17.17847 - January 11th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-242682: Deploying a memory optimized table type will now longer ignore indexes when the option is set

14.4.16.17770 - January 5th 2021

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10950: Extended properties representing sensitivity classifications are now treated as sensitivity classifications on versions of SQL Server that support the ADD SENSITIVITY CLASSIFICATION syntax
• Fix a crash when opening the Server dropdown in SQL Snapper

14.4.15.17626 - December 14th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• DifferenceFilter now exposes SaveToStream and LoadFromStream methods

Fixes

• External tables are no longer erroneously registered as regular tables
• SC-10945: Role members are now sorted in the SQL view

14.4.14.17548 - December 7th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• IDatabase.CompareWith now takes IDatabase instead of Database

14.4.13.17493 - November 30th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10946: Security policies now respect the “Add object existence checks” option

14.4.12.17429 - November 25th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.11.17350 - November 16th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.10.17174 - November 3rd 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.9.17070 - October 26th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10928: Fixed regression where static data could not be deployed to a table referenced by a system named foreign key.
• SC-6959: Comparing spatial indexes no longer gives false differences.

14.4.8.17007 - October 19th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.7.16962 - October 12th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SQL Compare now generates correct update script when changing data type of PK column of temporal table

14.4.6.16906 - October 5th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10919: Improved handling of SQL SET statements in scripts folders
• SC-4733: When the Ignore Permissions option is enabled, and a table is rebuilt, SQL Compare now restores its original permissions rather than deploying its original permissions

14.4.5.16856 - September 28th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.4.4.16824 - September 23rd 2020

Strapline

10 - Bug fixes

Fixes

• Static data differences are now correctly shown in the command line list of differences when using /include:staticdata

14.4.3.16779 - September 16th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10907: Amended script order when adding an IDENTITY field to a temporal table.
• SCA-2749: When comparing a scripts folder using /include:staticdata, SQL Compare Command Line will no longer compare data for tables without static data defined.

14.4.2.16694 - September 7th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10906: SQL Compare no longer tries to recreate an existing clustered columnstore index when a column’s datatype is modified

14.4.1.16663 - September 2nd 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD-166228: Fixed “SQL Change Automation scripting error”

14.4.0.16632 - August 24th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Improved consistency between command line and UI behaviours

14.3.4.16598 - August 19th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10897: Fixed “Multi-module assemblies are not supported when loading from memory”

14.3.3.16559 - August 11th 2020

Strapline

10 - Bug fixes

14.3.2.16501 - July 30th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• The current highlighted row in the differences grid is deselected (de-highlighted, not unticked.) after a refresh.
• SC-10890: Azure AD users are now registered on an Azure SQL database
• SC-10891: When generating a script for a partition scheme change, an exception is no longer thrown

14.3.1.16487 - July 27th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Spurious ‘Table rebuild fields dropped’ warnings are no longer displayed during a table rebuild

14.3.0.16423 - July 20th 2020

FREQUENT UPDATES RELEASE

Strapline

20 - Azure AD password auth on Linux

Engine API

• Engine now uses Microsoft.Data.SqlClient instead of System.Data.SqlClient
• Engine now depends on SmartAssembly.Attributes package

Features

• SQL Compare will now reject self-signed certificates when connecting over the internet to SQL Servers with force encryption enabled
• SQL Compare command line on Linux now supports Azure Active Directory Password authentication

14.2.19.16383 - July 13th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.2.18.16317 - July 6th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10852: Fixed SQL Server version not being read from SSDT/SCA project file
• SC-10853: When rebuilding an index, the order of included columns is now respected
• SC-10865: Fixed the filter pane behaviour when changing All Object Types.
• ZD160360: Fixed an occasional hang when comparing CLR assemblies.

14.2.17.16188 - June 23rd 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• SQL Compare Engine no longer references RedGate.Reflector.Compare.

Fixes

• SC-10851: Fixed object existence check when changing between a SQL function and a CLR function
• Fixed an issue with registering scripts folders on Linux.

14.2.16.16006 - June 4th 2020

Strapline

10 - Bug fixes

Fixes

• SC-10848: Fixed issue where saved passwords could be forgotten

14.2.15.15984 - June 1st 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Fixed Azure AD authentication when using the command line

14.2.14.15839 - May 18th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Removed SeparateTriggers option.

Fixes

• SC-7052: Only warn about potential data loss when precision/scale has changed in a way that could lose data.

14.2.13.15781 - May 11th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Improved startup performance in cases where networking issues were delaying product start.

14.2.12.15739 - May 4th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• ZD160292: In the diff view, permissions are now sorted by user and then by action.

14.2.11.15654 - April 29th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• SC-10818: Stop trying to register triggers on tables we do not register when SeparateTriggers is specified in the options.

14.2.10.15571 - April 22nd 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.2.9.15508 - April 9th 2020

Strapline

10 - Bug fixes

14.2.8.15465 - April 6th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10806 Fixed an issue that could occur while dropping tables with foreign keys with a scripts folder target
• SC-10801: Fixed the case when a computed column is added to a temporal table.

14.2.7.15427 - March 30th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.2.6.15412 - March 23rd 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

14.2.5.15352 - March 16th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10797: Fixed a script ordering error when altering a queue with an event notification on it
• SC-10798: Fixed support for newer SQL Server features (introduced in SQL Server 2016 or later) on Azure Managed Instances

14.2.4.15334 - March 5th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Fix performance issue with large text objects when the “Ignore WITH element order” option is enabled.
• SC-10795: Fixed a crash when opening the Create Scripts Folder dialog

14.2.3.15242 - March 2nd 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10786: When dropping a user with a permission set on a built-in user from a scripts folder, the permission will now be removed from the built-in user

14.2.2.15139 - February 24th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10785: When dropping a column, clustered columnstore indexes on the table are no longer dropped

14.2.1.15041 - February 11th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10773: Scripts folders containing Microsoft Database projects are now correctly recognized
• SC-10774: When using the “Don’t use transactions in deployment scripts” option, SQL Compare no longer includes a rollback statement at the end of the script
• SC-10777: Deploying a trigger change to a scripts folder no longer causes duplicate EXEC sp_settriggerorder statements
• SC-10776: When sys.sql_expression_dependencies claims a dependency against an object that does not exist in the database, SQL Compare now ignores the dependency and outputs an error to the logfile
• SC-10763: Scripts folders without a valid metadata file will now default to SQL Server 2019 instead of SQL Azure DB

14.2.0.14846 - January 29th 2020

FREQUENT UPDATES RELEASE

Strapline

20 - Azure AD interactive auth

Features

• SQL Compare now supports Azure Active Directory Interactive Authentication

Fixes

• SC-10766: When mapping schemas, object text will now preserve three and four part naming

14.1.10.14805 - January 27th 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10738: Changing a column from a user defined type and simultaneously dropping that user defined type no longer attempts to rebind the type after dropping it
• SC-10759: Create Partition Scheme statements in scripts folders which contain too many filegroups for their partition function will now be read in as SQL Server does, i.e. the excess filegroups will be ignored
• SC-10748: Permissions on the ‘dbo’ special user are now registered correctly
• SC-10765: The null unicode character no longer causes lines to be truncated prematurely when using the command line with static data

14.1.9.14719 - January 21st 2020

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10754: When deploying a user with only trailing space differences in the username to a user being dropped, the drop now happens before the create
• SC-10731: Filtered indexes with variant capitalisation in scripts folders now retain their WHERE clauses if the database collation is case insensitive
• If you have broken entries in your sys.database_permissions table we now ignore them rather than throwing a null reference exception

14.1.8.14471 - January 7th 2020

FREQUENT UPDATES RELEASE

Strapline

20 - Azure AD user support

Features

• SQL Compare now supports Azure Active Directory users

Fixes

• SC-10741: SQL Compare can now parse inline filtered indexes
• Improved compatibility with scripts folders with CREATE OR ALTER statements in
• SC-10744: Ignore Users now no longer also ignores roles that exist only in the target
• The open projects button no longer exhibits erroneous dropdown behavior

14.1.7.14336 - December 18th 2019

Strapline

20 - ONLINE=ON option

Features

• The option to use ONLINE = ON now covers altering columns as well as creating indexes. Note that the option name in the command line has been renamed from OnlineIndexBuild to AddOnlineOn to reflect this change.

14.1.6.14245 - December 16th 2019

FREQUENT UPDATES RELEASE

Strapline

20 - Backup before deploy on Azure managed instances

Features

• SQL Compare now shows a warning when trying to deploy a route with a non-local address to an Azure Managed Instance
• Azure Managed Instances can now take backups before deployment to a supplied URL.

Fixes

• SC-10727: Sensitivity classifications are now correctly added to columns of temporal tables.

14.1.5.14025 - December 2nd 2019

FREQUENT UPDATES RELEASE

Strapline

20 - Improved Azure support

Engine API

• ScriptDatabaseInformation now has a SqlVersion field (as well as retaining previous version information for backwards compatibility) in order to have an EngineEdition. If it isn’t given one, it will set the engine edition to AzureSqlDatabase if IsAzure is set and Unknown otherwise.

Features

• When you drop an object from a scripts folder, SQL Compare will now delete the file rather than leaving an empty file. We used to deliberately leave the empty file because some older source control systems would replace the file if it was deleted without also registering the deletion with the source control system, but these have mostly fallen out of use now. SQL Compare will not delete any file that is not completely empty - e.g. if there were other statements in the file that didn’t belong to that object, or if we can’t decrypt an object, or we had to generate it as dynamic SQL (e.g. routes with lifetimes), dropping the object will leave the file behind.
• SQL Compare will now install the Microsoft Active Directory Authentication Library if it is required
• Azure Managed Instances are now treated as a separate server version which takes into account the additional features they support. SQL Compare does not currently support memory optimized tables on Azure Managed Instances and will ignore compatibility level on these instances regardless of option state.
• Azure SQL Database supported feature list has been updated to reflect support for AUTO_GRID on spatial indexes.

Fixes

• Rebuilds that also add a history table no longer fail when the table contains data
• SC-10715: Indexes on history tables are now deployed when the history table is first created
• SC-10696: Temporal tables can now be deployed to Azure Managed Instances without warnings

14.1.4.13974 - November 25th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10707: Deploying a change no longer keeps an old object difference visible
• SC-10680: Rebuild table when nullability changes on a field used by a partition function

14.1.3.13888 - November 18th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• New option to add the ONLINE = ON option when creating relational indexes
• SQL Compare parser now supports “ALTER ANY EXTERNAL LANGUAGE”, “CREATE EXTERNAL LANGUAGE”, “EXECUTE EXTERNAL SCRIPT”, and “VIEW ANY SENSITIVITY CLASSIFICATION” permissions

Fixes

• SC-10695: Comments ending a line in a backslash in text-based objects now generate a warning when Object Existence Checks are on, because they cause sp_executesql to believe they contain a line continuation character and the resulting object has the following line commented out.
• SC-10656: The UI no longer locks up when generating a script while including a large number of dependencies
• SC-10697: Deploying a non-default owner of a system role to a scripts folder now works correctly
• SC-10706: Snapshot deserialization now correctly deserializes Storage objects on temporal tables
• TBI-419: When uninstalling SQL Compare 13, the installation folder and start menu shortcut are now cleaned up

14.1.2.13797 - November 11th 2019

FREQUENT UPDATES RELEASE

Strapline

20 - Ignore Data Masking option

Features

• SC-10689: Ignore Data Masking option now available - this will act as if neither of your databases have any MASKED clauses on columns.

Fixes

• SC-10690: Using expressions like CAST inside an OPENJSON statement no longer causes a parser exception.
• SC-10693: sp_addrolemember in scripts folders without a corresponding role or user for the member no longer creates schemas
• SC-6380: CLR assemblies with extra files now do object existence checks correctly on assembly creation.
• SC-10654: Launching SSMS 18 from SQL Compare now behaves correctly when using SQL Authentication

14.1.1.13725 - November 5th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• You can no longer add a backup statement to a script that is immediately run on an Azure server, which would always cause the script to fail.
• SQL Compare no longer attempts to connect to an Azure SQL Database to check SQL Backup install status or do folder browsing, neither of which work on Azure SQL Database.
• SC-10684: Auth-based objects which have non-default AUTHORIZATION set now correctly register permissions.
• SC-10694: Stored procedures that contain multiple conversation handles in SEND ON CONVERSATION statements can now be parsed successfully
• ‘master’ no longer appears on the database list for Azure SQL Database and we no longer allow you to register it, as it is not really a full database and may have unexpected behaviour.

14.1.0.13605 - October 28th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Improved error messages around Azure Active Directory authentication.
• Renamed several comand line options for clarity. The old names are still functional: | Old option name | New option name | Alias | |—————–|—————–|——-| | CaseSensitiveObjectDefinition | UseCaseSensitiveObjectDefinition | cs | | IgnoreKeys | IgnoreForeignKeys | ifk | | IgnoreChecks | IgnoreCheckConstraints | ich | | IgnoreFileGroups | IgnoreFileGroupsPartitionSchemesAndPartitionFunctions | ifg | | IgnoreIdentitySeedAndIncrement | IgnoreIdentitySeedAndIncrementValues | isi | | IgnoreConstraintNames | IgnoreConstraintAndIndexNames | icn | | IgnoreSystemNamedConstraintNames | IgnoreSystemNamedConstraintAndIndexNames | iscn | | IgnoreQueueEventNotifications | IgnoreEventNotificationsOnQueues | iqen | | UseClrUdtToStringForClrMigration | DontAlterAssembly | daa | | IgnoreIndexLockProperties | IgnoreLockPropertiesOfIndexes | ilpi | | IgnoreIdentityProperties | IgnoreIdentityPropertiesOnColumns | iip | | IgnoreDatabaseAndServerName | IgnoreDatabaseAndServerNameInSynonyms | idsn | | DecryptPost2kEncryptedObjects | DecryptEncryptedObjects | deo | | DropAndCreateInsteadOfAlter | DropAndCreateForReRunnableScripts | dac | | ObjectExistenceChecks | AddObjectExistenceChecks | oec |

14.0.7.13517 - October 21st 2019

Strapline

10 - Bug fixes

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

14.0.6.13387 - October 14th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

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

14.0.5.13297 - October 7th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

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

14.0.4.13251 - October 2nd 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

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

14.0.3.13106 - September 23rd 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

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

14.0.2.13006 - September 16th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

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.

14.0.1.12901 - September 9th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

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

14.0.0.12866 - September 4th 2019

Strapline

60 - SQL Server 2019 support 50 - Linux command line support

Engine API

• SDOC-1935: ForeignKey objects that reference default FileTable fields can now use ReferencedFields getter without throwing

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

13.8.0.12703 - August 27th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10625 - CONCAT_WS is now recognised as a system function on SQL Server 2017 and above.
• SC-10644 - The ‘drop and create instead of alter’ option has been renamed ‘use drop and create for rerunnable scripts’ and had the ‘drop and create instead of create’ functionality restored. It still only works on some object types, which are listed in the option description.
• SC-10641 - text objects (e.g. stored procedures) that reference system queues no longer cause a crash in dependency processing
• SC-10630 - WITH CHANGE_TRACKING_CONTEXT with a literal parameter (as opposed to a variable) no longer causes a parsing error when registering from a scripts folder

Internal

• Removed ability to load snapshot files from a URL. This was never a supported feature, and was only implemented to support an experimental DLM Dashboard Down Tools Week project.

13.7.22.12352 - August 12th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Updated System.Data.SQLite.Core 1.0.110 -> 1.0.111

Fixes

• SC-10604: Option text for Ignore Indexes updated to reflect operation of this option with a script folder target

13.7.21.12250 - July 31st 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10605: Compare will now not drop foreign keys on unselected tables when Include Dependencies is off, even when this will cause the database to be left in an inconsistent state / the deployment script to fail.

13.7.20.12175 - July 29th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Prevented a hard crash (stack overflow) when parsing very complex constraints, defaults and computed columns. A log error will be recorded if this happens.
• Fixed a crash when SQL contains hundreds of nested parentheses.

13.7.19.12066 - July 22nd 2019

Strapline

10 - Bug fixes

Fixes

• Schemabound views and functions will now avoid taking changes unless selected. A medium level warning will be raised when this might cause a script failure.
• SC-10592: Statistics column order is now taken into account when the Force Column Order option is selected.
• SC-10594: SQL Compare will no longer produce an error when deploying a temporal table with a custom-named history table in the target which has the same name as another table in the source.

13.7.18.11916 - July 15th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-8949: ANSI current_timestamp syntax now reads correctly from scripts folder
• SC-10569: Warning added for downgrade of AUTO_GRID tesslation schemes in spatial indexes
• SC-10575: Compare now correctly parses the case where you have both an XML NAMESPACES and a CTE in a cursor declaration within a stored procedure.

13.7.17.11774 - July 8th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10528: Improved performance calculating work when many default constraints are present
• SC-10562: Improved error message when your scripts folder contains a field with an invalid data type
• Impersonate permissions on roles and schemas now deploy correctly
• Old (pre-v13) snapshots should now load quicker

13.7.16.11325 - June 13th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Fixed a bug where necessary whitespace would sometimes not be included in the migration script when renaming a table which is referenced in a procedure.
• Synonym dependencies behaviour has changed
• SC-10524: SSMS 18 now correctly listed in application options
• Text object dependencies can now disambiguate between types and tables with the same name

13.7.15.11228 - June 6th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10531: Comparing two different Git revisions using the SQL Compare command line now works
• SC-10516: Columnstore index columns can no longer incorrectly be marked as DESC
• SC-10510: Updating a scripts folder when the only change is alters to XML schema collections now works

13.7.14.11151 - June 3rd 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Error handling statements added between route drop, XML schema collection drop/unbind and view refresh statements
• SC-10528: Corrected a performance issue when comparing default constraints
• SC-10519: Backups created with SQL Backup using multiple threads and with CHECKSUM enabled are now supported

13.7.13.10771 - May 13th 2019

Strapline

10 - Bug fixes

Fixes

• SC-10455: Scripts folder deployments now restore pre-existing permissions if Ignore Permissions option is set
• SC-10505: Fixed an issue parsing stored procedures preceeded by a nested comment, that could result in an a crash, or an incorrect diff being shown when the “Ignore authorization on schema objects” option is set
• Ignore SET QUOTED_IDENTIFIER and SET ANSI_NULLS option now also removes those from the initial SET statement, and additionally removes the deprecated SET option ANSI_PADDING from that statement
• Fixed error on generating deployment script when a text object (e.g. a stored procedure) referenced a history table directly
• Summary view tab no longer ‘hidden’ in some circumstances
• SC-10509: Default generated history table schema for scripts folder registration no longer contains the NOT FOR REPLICATION clause for columns that were identity columns with NOT FOR REPLICATION on the main table

13.7.12.10555 - May 7th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Local objects that share the same name as a dependent object in another database are no longer seen as a dependency
• SC-10496: Object existence checks no longer appear in the diff view when the “Add object existence checks” deployment option is enabled
• Fixed issues when running SQL Compare in a non-English locale, including SC-10487 where FILLFACTOR was ignored in scripts folders when running in a Turkish locale

13.7.11.10438 - April 29th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Error handling statements now in place between assembly drops to ensure we stop as soon as an error is encountered
• SC-10477: We now deploy changes to partition schemes that are required by partition function changes, even if they would otherwise be ignored because the ConsiderNextFilegroup option is turned off

13.7.10.10373 - April 23rd 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• Role and user modifications will now usually be done within the transaction rather than beforehand (unless they must be done beforehand because of limitations of SQL 2005/8 or full text objects depending on them)
• Partition Schemes now select their dependencies if Include Dependencies is specified and Ignore Filegroups is turned off. Table drops will generate a High warning if generated.

Fixes

• SC-10470: An exception is no longer thrown when updating a column in a scripts folder during a table rebuild from a type with no length to a type with length
• SC-10474: SSDT projects are now recognized if the only version of MSBuild installed is 15
• SC-10103: Partition Functions now no longer pull in non-selected partition schemes that didn’t already exist in the target.
• Fixed a rare occurence where a table rebuild caused by CLR UDT change would drop the table off its filegroup or partition scheme back to PRIMARY
• We now use ALTER ROLE ADD / DROP MEMBER rather than sp_addrolemember/droprolemember on SQL2012 and above

13.7.9.10201 - April 10th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• Added a new project guid property to the RedGateDatabaseInfo xml file. This property will be used to track SQL Source Control usage across other Redgate products

Fixes

• SC-8035/SDC-1978: SQL Compare no longer throws an exception in a situation where SQL Server doesn’t provide column type information
• SC-10461: Security policies that depend on functions that are being dropped, will no longer be recreated if they are also being dropped

13.7.8.10109 - April 1st 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Added some logging to foreign key population; now avoids nullref when referenced table cannot be found
• SC-10449: Rebuilding a computed column will no longer drop an index on the column
• Added some logging to foreign key population; now avoids nullref when referenced table cannot be found
• Remove duplicate drop action messages for service broker objects
• Add error handling statements between history table clustered index creation, table creation and sp_tableoption calls

13.7.7.10021 - March 26th 2019

Strapline

10 - Bug fixes

Fixes

• Error handling statements are now added between each foreign key and computed column drop, reducing extra statements executed in a failure state
• Reduced the number of duplicate error handling statements in a row added around several statements
• When FIPS mode is enabled, SQL Compare will still not be able to decrypt an object but will no longer throw an error
• SC-10443: “Sequence contains no matching element” when schemas are cross-mapped
• When a stored procedure might be broken due to being excluded from deployment, SQL Compare will no longer insist on deploying changes to it.
• SC-10454: Tables with edge constraints are now dropped before the referenced node tables

13.7.6.9920 - March 18th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• RedGate.SQLCompare.ASTParser and RedGate.SQLCompare.Engine NuGet packages have been updated to include both net461 and netstandard2.0 content. The .NET STandard 2.0 versions are not yet ready for public consumption.

Fixes

• CLR type related table rebuilds will now also correctly rebuild all computed columns that reference the affected column, not just those with a method call
• SQLite dependency upgraded to version 1.0.110

13.7.5.9811 - March 11th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Engine NuGet packages now have the packaged assemblies delivered in the lib\net461 folder, rather than the lib folder directly.
• RedGate.SQLCompare.Rewriter has been updated to target both net461 and netstandard2.0

Fixes

• SC-10437: Tables on different filegroups are no longer rebuilt when there is a maximum length text column and the “Ignore Filegroup, partition schemes and partition functions” option is enabled
• SC-10439: DROP PROC IF EXISTS no longer causes a parser error

13.7.4.9637 - February 28th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• The Redgate.ThirdParty.LibGit2Sharp fork has been removed and we are now using the mainstream LibGit2Sharp.

Fixes

• SC-10427: Occasional unnamed default constraints that would erroneously appear will now not appear
• SC-10407: Static data is no longer omitted from a command line comparison when the table doesn’t exist in the target and a project file is being used
• SC-10019: Excluded object types are no longer shown in the report if the /include:Identical switch is used
• SC-10435: ODBC escape sequences for LIKE clauses can now be parsed
• SC-10434: The classic report now renders correctly

13.7.3.9483 - February 20th 2019

Strapline

10 - Bug fixes

Engine API

• RedGate.SQLCompare.Engine now uses Microsoft.Build instead of Microsoft.Build.Engine, which is deprecated

Fixes

• Fixed a threading deadlock when the source is a scripts folder
• SC-10420: Adding a NOT NULL constraint to a column with a default constraint and an index will no longer fail deployment due to recreating the index before changing nullability
• When creating a table that has rule bindings, those rules are now updated as dependencies
• Default objects are now no longer rebuilt if there are only extended property or permission changes
• Defaults and rules are no longer applied futureonly on UDTs - this means they will apply themselves to any table fields the UDTs are applied to

13.7.2.9407 - February 18th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• The ongoing migration of our project files to the VS 2017 format may introduce subtle changes to the various Compare and Data Compare NuGet packages.
• The RedGate.SQLCompare.ASTParser and RedGate.SQLCompare.Engine NuGet packages now include some previously missing NuGet package dependencies. These may potentially result in downstream dependency conflicts.
• Removed unwarranted NuGet package dependency on Microsoft.Build.Engine that is both deprecated and caused downstream version conflicts.

Fixes

• Added some extra error handling statements around role memberships
• SC-8716: Changing the name of a default constraint now no longer unnecessarily drops and recreates indexes that reference the same column

13.7.1.9280 - February 11th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10382: Clustered columnstore indexes are no longer rebuilt when adding a column to a table and the “Ignore constraint and index names” option is set
• SC-10408: An exception is no longer thrown when updating a column in a scripts folder from a type with no length to a type with length
• SC-10409: A duplicate index definition is no longer created when updating the schema of a temporal table in a scripts folder

13.7.0.9250 - February 7th 2019

Strapline

30 - Edge constraints 10 - Bug fixes

Engine API

• The Options property on SqlProvider and ComparisonSession is no longer mutable. Options must be passed into the constructor.
• EngineDataCompareOptions is now immutable. Modified copies can be created using the .With and .Without extension methods.

Features

• SQL Compare now supports comparison and deployment of edge constraints

Fixes

• SC-10393: SQL Compare now supports the DATA_COMPRESSION keyword on spatial indexes

13.6.14.9174 - February 4th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Made underlying CompareWith methods for individual objects which have an explicit ISqlComparable implementation private
• Deleted all obsolete Index properties - there are alternatives for all of these (mostly ‘cast to RelationalIndex or SpatialIndex’, one renamed property - FileGroup to FileGroupOrPartitionScheme)
• Removed two obsolete FK properties

Features

• Adds a new option to ignore sensitivity classifications on fields
• Additional logging of .NET assembly loading to help investigate SDC-2906.

Fixes

• SC-10397: SQL Compare now sets the correct value for NATIVE_COMPILATION when reading from a scripts folder
• SC-10398: Fixed a snapshot deserialization crash for case differences in column names between temporal and history tables
• SC-10402: Dropping temporal tables with columns that depend on a user defined type no longer throw an exception

13.6.13.9079 - January 31st 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Rich dependencies are now accessible via the ActionableDependencies property on Database

Fixes

• SC-10382: Clustered columnstore indexes are no longer rebuilt when adding a column to a table
• SC-5024: SQL Compare now reads the correct value for TRACK_COLUMNS_UPDATED from a scripts folder
• SC-10398: Fixed a snapshot deserialization crash for case differences in column names between temporal and history tables

13.6.12.9031 - January 28th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Constructors for Work, VersionedWork, SqlGenerationQueueBuilder, and DeploymentOptions now require setting the transaction isolation level, and those classes no longer have a settable TransactionIsolationLevel property.

Fixes

• SC-10386: Fixed a crash when saving filetables to snapshot
• SC-10387: Fixed a crash when loading filetables from snapshot
• SC-10385: SQL Compare no longer unnecessarily rebuilds graph tables when the “Force column order” option is set
• SC-10306: SQL Compare no longer throws an exception when comparing mapped tables with check constraints

13.6.11.8947 - January 23rd 2019

Strapline

10 - Bug fixes

Fixes

• Fixed an issue with SOC integration

13.6.10.8927 - January 22nd 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10357: Scripts folders containing POISON_MESSAGE_HANDLING statements in queue alters can now be registered
• SC-10157: we now deploy bound rule/default changes with UDT changes, so that incompatible rules and defaults no longer prevent use of the UDT
• SC-10375: When comparing a normal table to a temporal table, the SQL for the normal table now correctly matches up with the temporal table SQL rather than the history table SQL in the diff view

13.6.9.8731 - January 14th 2019

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10353: SQL Compare no longer duplicates comments that follow an OR keyword when generating a deployment script
• SC-10365: Rebuild calculation for graph tables no longer crashes when comparing a live source to a scripts folder
• SC-10366: SQL Compare can now read indexes on hidden columns of graph tables from a scripts folder
• SC-10373 Comparing an NVARCHAR(MAX) to a VARCHAR(x) for x > 4000 no longer gives spurious truncation warning
• SC-10373 Comparing VARCHAR/CHAR to NVARCHAR/NCHAR will give warning about potential Unicode corruption

13.6.8.8602 - January 8th 2019

FREQUENT UPDATES RELEASE

Strapline

15 - Keys first 10 - Bug fixes

Features

• SQL Compare now puts the commented out SQL for keys at the top of the script, along with certificates, so they are easier to spot.

Fixes

• SC-10319: SQL Compare recognises primary keys on filetables so they can be referenced by other objects
• SC-10339: Adding a column to a table with a history table doesn’t attempt to re-create an existing index
• SC-10351: SQL Compare now successfully parses the PREDICT function
• SC-10355: SQL Compare can now read more than one sensitivity classification per table in a scripts folder
• SC-9815: SQL Compare will now not overwrite the RedGateDatabaseInfo.xml with default options when deploying from the command line
• SC-10369: SQL Compare will now deploy permissions to the history tables of temporal tables
• SC-10371: SQL Compare now correctly redeploys multiple predicates that depend on the same function and apply to the same table
• SC-10360: SQL Compare no longer throws an exception when a stored procedure ends in a SET ANSI_NULLS statement and certain options are set

13.6.7.8464 - December 18th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10321: SQL Compare will no longer attempt to create an index on a view without dropping it when triggered by only a change in an assembly
• SC-10336: Unique indexes on memory optimized tables now stay unique when deployed to scripts folders

13.6.6.8387 - December 11th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• An extra IWork member is available, DependenciesForUi. This pre-filters the dependency list to exclude dependency relationships which haven’t actually had any effect on the final deployment (e.g. the object was already selected).

Fixes

• SC-10323: SQL Compare now handles column definitions containing TRIM
• SC-10303: SQL Compare no longer ignores permissions on domain users
• SC-10271: SQL Compare now refreshes relevant views after unbinding user-defined data types from tables in order to safely modify the type
• SC-10031: SQL Compare doesn’t highlight differences between CREATE and CREATE OR ALTER statements
• SC-10311: SQL Compare now respects dependencies correctly when a user defined type and a table have the same name
• Unbinding XML Schema Collection from a table now shows up as a dependency in the UI dependency list
• SC-10333: SQL Compare can now parse aliases with missing column lists in nested SELECT statements
• SC-10338: Fixed some confusion between permissions on tables and types that have the same name

13.6.5.8288 - November 26th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Made all Options members which are options or groups of options readonly
• Made Options.TryParseOptionName private as it didn’t seem to be externally used

Features

• SC-10288: Added an option to add NO POPULATION to fulltext indexes on creation, so that population can be started at a better time than deployment time

Fixes

• XML Schema Collections on UDTTs now have dependencies treated correctly and don’t produce an exception in the deployment wizard
• Fixed some deployment crashes when certain changes are queued multiple times
• SC-9552: Apply the correct filter on initial load of a project when the filter has been loaded from the data source
• SC-9907: Don’t generate an ALTER statement for a sequence which only has permission changes
• SC-10299: Double precision data types can now be parsed with a length parameter
• SC-10302: SQL Compare can now parse stored procedures that manipulate security policies

13.6.4.8233 - November 21st 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10298: Filters are now correctly loaded from a SoC checkout
• SC-10262: SQL Compare doesn’t attempt to update default values in a non-nullable column before the default value has been added
• SC-10300: SQL Compare can create a snapshot from a SQL Change Automation project using the command line
• SC-10274: SQL Compare can alter multiple computed columns that depend on the same column when altering the column type
• SC-10276: SQL Compare handles altering the primary key while creating/dropping columns in a temporal table
• No longer has a specific warning for non-table rebuilds based on xml schema collection changes - uses the standard dependency list to signal this happening instead
• XML Schema Collections referenced by message types are no longer pulled in when the message type is altered - SQL Server will always accept this change so there’s no need to enforce the dependency
• XML Schema Collection dependencies are now treated the same in scripts folders as they are in live databases (avoiding invalid scripts folders where modules depend on old version of XML Schema Collections)

13.6.3.8160 - November 12th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Fixed typo in DBPopulationOptions - ExcludeAssemlyFiles is now ExcludeAssemblyFiles
• Significantly reduced external surface area of DatabaseFactory - please whinge if you were using any of the things I made internal/private
• RegisterForRefactoring and RegisterGetObjectOwners no longer separately set up object collections, and generally use more normal population rather than special case stuff - this should be fine but SQL Prompt should be vigilant when taking this update
• Fixed null ref in snapshot deserialization when there is a dependency involving a UDTT and there is a UDT present too. (SOC-9649)

Fixes

• SC-9891: History tables aren’t shown twice in the SQL View when the Force Column Order option is set
• SC-10283: SQL Compare can distinguish between roles and schemas with the same name when altering permissions
• SC-10285: ADD/DROP HIDDEN clauses in ALTER TABLE ALTER COLUMN statements now parse correctly
• Log missing parents of triggers rather than throwing an exception
• Check that datatypes can cast to each other now takes into account the base type of UDTs

13.6.2.7987 - October 23rd 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• SC-10215: Add support for sp_tableoption ‘large value types out of row’

Fixes

• SDC-2747: When resizing the comparison key window in a mapping dialog, the scrollbar no longer disappears
• SDC-2894: The command line now exits with the correct exit code when the license is invalid
• SC-9126: Permissions are mapped correctly when users are windows principals with differing domains
• SC-10267: The color coding in the single object deployment script window is now aligned correctly

Internal

• The SQL Compare UI build now runs the Compare Engine through SmartAssembly

13.6.1.7928 - October 17th 2018

Strapline

10 - Bug fixes

Fixes

• SC-10230 Pressing the “Next” and “Previous” buttons in the SQL diff view will now skip differences in headings
• SC-10234 SQL Compare now supports TRIM functions
• SC-10269 SQL Compare no longer leaves SET statements in a scripts folder when a CLR function has been deleted
• SC-10253, SC-10255, SC-10272: Fixed a performance issue when ignoring NOT FOR REPLICATION

13.6.0.7862 - October 15th 2018

FREQUENT UPDATES RELEASE

Strapline

30 - Sensitivity classifications 10 - Bug fixes

Features

• SQL Compare now supports comparison and deployment of sensitivity classifications
• SQL Data Compare options can now be specified with the /datacompareoptions switch when deploying static data through the SQL Compare command line.

Fixes

• SC-10264: User defined types that are dependencies will no longer be deployed if the option to include dependencies is not set
• The DataFileSet node of the RedGateDatabaseInfo.xml file in a scripts folder has been deprecated and no longer affects static data deployment

13.5.2.7785 - October 9th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10202: Improved handling of history tables that whose definitions were not included in a scripts folder
• SC-10257: Queues and stored procedures that form a circular dependency are now deployed in the correct order when the source is a scripts folder
• SC-10260: SQL Compare now handles snapshots containing temporal tables that were made using Compare version 12
• SC-10261: Foreign key constraints can be set as CHECK or NOCHECK in a folder even when the option to ignore constraint names is set

13.5.1.7638 - September 24th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10227: SQL Compare no longer throws an error when dropping a block predicate with a specified DML operation
• SC-10239: Queues and stored procedures that form a circular dependency are now deployed in the correct order
• SC-10241: Command line no longer throws an error when only using the /activateSerial or /deactivateSerial switches
• SC-10243: Fix error with adding permissions to an object when ignoring users

13.5.0.7565 - September 17th 2018

FREQUENT UPDATES RELEASE

Strapline

30 - SCA projects 10 - Bug fixes

Features

• Added support for using SQL Change Automation projects as a data source in SQL Compare. For more information on using SQL Change automation projects in SQL Compare see https://documentation.red-gate.com/sc13/working-with-other-data-sources/working-with-sql-change-automation-projects

Fixes

• SC-10221: A create index statement with a string literal as a filegroup name will no longer cause a parser error
• Fixed the sca2 command-line parameter not being recognised
• SC-10223: SQL Compare no longer explicitly deploys default data spaces
• SC-9932: SQL Compare command line no longer normalises all line endings to CRLF when adding static data

13.4.8.7337 - September 3rd 2018

Strapline

10 - Bug fixes

Engine API

• The SQL Compare Engine package no longer references Microsoft.SqlServer.SqlManagementObjects

Features

• Added Command line suppport for deploying the state represented by SQL Change Automation Projects. This is the offline schema model and programmable objects. This can be done using the sca1 and sca2 command line parameters, which should specify the path to the .sqlproj.

Fixes

• SC-9458: Partition functions with datetime2(0) parameters now have the precision registered correctly when being read from a scripts folder
• SC-10188: SQL Compare now ignores instance-specific functions generated by Change Data Capture
• SC-10203: Updated the description for ‘Ignore Constraint Names’ and ‘Ignore System Named Constraint Names’ options
• SC-10204: Ignore not for replication now works correctly when not for replication is set at the end of a line and ignore whitespace is not set
• SC-10212: The return value of sp_addrolemember is now checked to improve error handling
• Fixed a null reference exception where a CLR type depends on an assembly that is being created
• Fixed a null reference exception when loading a snapshot from an older version of SQL Compare that was created from a scripts folder

Internal

• Fixed a constructor ambiguity in the ComparisonContext class

13.4.7.7223 - August 20th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Symmetric Keys now output a comment with various key properties in lieu of being able to deploy changes again
• FunctionReturnTypeChange warning type renamed to FunctionTypeChange to more accurately reflect what it represents
• SC-10161: SQL Compare will now rebuild indexes on views that reference a CLR assembly.
• SQL Snapper now uses the correct case sensitivity setting when registering databases
• SC-10194: The classic report no longer generates invalid javascript when there are no equal objects and include identicals is not set
• SQL Compare now uses DBCC FREESYSTEMCACHE when modifying assemblies that are referenced by other assemblies

13.4.6.7079 - August 13th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10172: SQL Compare no longer incorrectly processes AT TIME ZONE in table expressions
• SC-10134: SQL Compare can now parse nested AT TIME ZONE statements with parentheses
• SC-10191: Commit statements without the TRAN or TRANSACTION keywords can now be parsed

13.4.5.6953 - July 30th 2018

Strapline

10 - Bug fixes

Fixes

• SC-10171: Null reference exception in serialisation fixed.
• SC-10178: Fix parser failure when TRY_PARSE(… USING <culture>) at the very end of a WHERE clause
• SC-10181: Parser will now accept a language variable as the language option when creating a natively compiled stored procedure
• SC-10185: Patching up dependencies when loading a snapshot will now correctly locate user defined table types

13.4.4.6883 - July 24th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10176: Parser now handles ordering by multiple columns in a STRING_AGG statement’s WITHIN GROUP clause
• Functions no longer rebuild or alter when the only change is extended properties, permissions or authorization
• SC-10065: Improved alteration of security polices on case insensitive databases
• SC-10177: Copying text from the diff viewer now preserves empty lines when the “Ignore whitespace” option is set

13.4.3.6777 - July 17th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Internal

• Added “in product notification” banner
• Added serialization for script sources from fields

13.4.2.6669 - July 2nd 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Removed unused parameters and overloads from Work and VersionedWork

Features

• SC-4757: Adds an “Ignore Change Tracking” option

Fixes

• SC-9272: Fixed script ordering for service broker objects referenced by schema objects
• SC-10123: Dependencies between user defined types and user defined table types are now respected when dropping them
• SQL Compare migration blocks will now correctly drop and recreate dependencies when necessary.
• SC-10069: Fixed dependencies bug between tables/views and their triggers when registering from a scripts folder
• SC-10151: Dropping a function referenced by a security policy now drops and recreates the security policy

13.4.1.6601 - June 25th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9870: SQL Compare no longer creates SET statements in the context of creating a scripts folder, when filtered indexes are included.
• SC-10145 Parse error on AT TIME ZONE with bracketed string literal fixed.

13.4.0.6563 - June 20th 2018

Strapline

30 - Schemas treated as schema objects 10 - Bug fixes

Engine API

• Database.RegisterForRefactoring() now requires the appropriate case sensitivity to be specified in the options.
• Refactorer.DefaultRefactoringOptions() is now a method, so that the database in question can be checked for case sensitivity.

Features

• SC-6601: The “Ignore authorization on schema objects” option now also includes schemas themselves

Fixes

• SC-6610: Deploying a varchar(4096) column or wider onto a varchar(MAX) no longer gives spurious warning about truncation. Deploying in the other direction gives the correct warning.
• SC-9834: Contracts and services with out of database / default / built-in message types and contracts, and some full text catalogs, no longer cause an exception when they exist in the target
• SC-9940: Fixed issue parsing AT TIME ZONE where the time zone is the result of a nested SELECT statement
• SC-10089: Deploying column changes to a fulltext index in a scripts folder will no longer create duplicate ALTER FULLTEXT INDEX statements
• SC-10104: Modifying a key index of a fulltext index will now drop the fulltext index before and recreate it later
• SC-10111: Changing the XML schema collection on a column will provide a more suitable warning
• SC-10118: The interactive HTML report no longer sees case differences in data types as a difference
• SC-10120: Copying text from the SQL differences pane to the clipboard now preserves line endings

13.3.8.6436 - June 11th 2018

Strapline

10 - Bug fixes

13.3.7.6422 - June 11th 2018

FREQUENT UPDATES RELEASE

Strapline

20 - Classic HTML Report 10 - Bug fixes

Features

• The old Interactive HTML report type has been reinstated as the Classic HTML report type

Fixes

• SC-10089: Deploying column changes to a fulltext index in a scripts folder will no longer create duplicate ALTER FULLTEXT INDEX statements
• SC-10100: Permissions on history tables are now registered correctly
• SC-10104: Modifying a key index of a fulltext index will now drop the fulltext index before and recreate it later

13.3.6.6375 - June 4th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-2813: CLR triggers will now be deployed if an assembly they require is rebuilt and Include Dependencies is on, even if their parent object is not selected, which avoids the deployment failing due to target CLR triggers that are no longer valid.
• SC-9791: The ‘DROP and CREATE instead of ALTER’ option is no longer ignored when creating a deployment script.
• SC-10050: Fixes crash when trying to deploy a Service that references a system-defined Contract
• SC-10077: Multi-line string literals now have difference highlighting applied correctly
• SC-10083: Adding a check constraint while rebuilding a table no longer causes an invalid deployment script
• SC-10086: Functions that are schema bound and omit ‘AS’ in their definition no longer cause an invalid deployment script
• SC-10095: Removing a column from a fulltext index on a view will now be flagged as a difference
• SC-10099: Altering the columns in a fulltext index on a view now produces a correct deployment script
• CLR triggers are now replaced when they need to be dropped to enable assembly rebuild.
• UDT changes in script folders now cause objects using the UDT to be deployed as dependencies, to ensure the script folder does not become inconsistent.
• UDTs no longer create objects that depend on the type as dependencies when you attempt to deploy just the type (they will still pull differences in objects that exist on both sides).

13.3.5.6244 - May 23rd 2018

Strapline

10 - Bug fixes

Features

• SQL Compare supports external language event types, which are now available on Azure

Fixes

• Telemetry has been updated in accordance with the privacy policy available at https://www.red-gate.com/website/legal

13.3.4.6198 - May 17th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Redgate.*.Obfuscated packages no longer built

Fixes

• SC-10080: SQL Compare again ignores line endings whitespace in string literals when IgnoreWhiteSpace switched on.
• SC-10050: SQL Compare can again handle Services with Contract dependencies not in the database that could just be arbitrary strings (e.g. as in the case with Query Notifications)
• IgnoreUsers now properly ignores role memberships again; role memberships are no longer ignored when IgnoreUsers is off
• extended properties on queue event notifications are no longer deployed when the IgnoreEventNotificationsOnQueues option is on
• SC-10025: SQL Compare more gracefully handles errors with missing schemas in a scripts folder
• SC-9713: Using the IncludeIdentical switch on the command line no longer rebuilds objects with default non_PRIMARY filegroups
• SC-10044: The existence of multiple DDL event types on the server that are unknown to SQL Compare will longer cause trigger registration to fail
• SC-10061: Double-clicking on a project in the ‘My projects’ screen now does ‘Compare now’ instead of ‘Edit project’
• SC-10062: Command line can deploy static data from a table with a primary key and unique index to a table with only a unique index
• SC-10072: Simple HTML option description removed from help widget in Generate Comparison Results Report dialog
• SC-10074: When rebuilding a temporal table, data from the GENERATED ALWAYS AS ROW START/END columns is now preserved
• SC-10077: When using “Ignore white space” option, nested string literals with whitespace differences now have highlighting applied

13.3.3.6037 - May 1st 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-10054: SQL Compare more gracefully handles errors with missing schemas in a scripts folder
• SC-10051: SQL Compare IgnoreFullTextIndexing option works as expected when NoTransactions switch on
• SC-10057: Command line no longer fails in certain scenarios when the /exclude switch is used with /include:identical

13.3.2.5875 - April 17th 2018

Strapline

10 - Bug fixes

Features

• SC-10044: SQL Compare now handles ADD_SENSITIVITY_CLASSIFICATION and DROP_SENSITIVITY_CLASSIFICATION event types

Fixes

• SC-10036: The SQL Compare command line will no longer fail when there is whitespace between options in an XML argument file
• SC-10014: SQL Compare now re-creates target performance indexes that had to be dropped for table changes when Ignore Performance Indexes option is on
• SC-10018: SQL Compare no longer tries to add constraints to a temporal table’s history table.

13.3.1.5775 - April 9th 2018

FREQUENT UPDATES RELEASE

Strapline

30 - Commandline active directory auth 10 - Bug fixes

Features

• SQL Compare command line now includes switches /activedirectory1 and /activedirectory2 to specify the use of Azure Active Directory authentication

Fixes

• SC-10022: SQL Compare no longer fails when deploying a filter predicate in a security policy where the number of arguments has changed

13.3.0.5760 - April 4th 2018

FREQUENT UPDATES RELEASE

Strapline

40 - Change to whitespace handling in strings

Features

• SC-9967: “Ignore whitespace” option is no longer applied to string literals

Fixes

• SC-10019: /exclude command line switch now correctly overrides /include:Identical in generated reports
• SC-10016: Fixed a bug where fulltext indexes on views with STOPLIST = OFF were incorrectly registered from live databases
• SC-9912: SQL Compare no longer crashes when scripting out a trigger it can’t parse
• Event notifications now select the Service that they’re on as a dependency, if it’s in the source database and IncludeDependencies is enabled
• SC-9948 Comparisons for a stoplist with NULL owner no longer crash

13.2.4.5728 - March 23rd 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• Differences.Remove() has been renamed to Hide(). Difference objects passed to this method will have their Selected property set to false.

Fixes

• SC-10005: SQL Compare now treats EXEC and EXECUTE permissions as equivalent.
• Fixed an installer bug that could occasionally cause data loss

13.2.3.5714 - March 21st 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9991: SQL Compare can now parse unique inline indexes correctly
• SC-9873: SQL Compare can now read spatial indexes on computed columns from scripts folders where the function name has inconsistent casing
• Deployment wizard now displays correct dependency set when you go back and change from script folder deployment to sql script generation.

13.2.2.5661 - March 12th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Engine API

• DT-711: Reading Filegroup on full text index when none was specifies now returns null rather than crashing

Fixes

• SC-9950: Fixed some spuriously copied permissions and triggers between temporal and history tables in scripts folders
• SC-9975: DateTimeOffset parameters are now read from scripts folders correctly
• SC-9953: SQL Compare now wraps the index name in square brackets when enabling or disabling an index
• SC-9947: Data compression on tables with clustered indexes is now more accurately read from scripts folders
• SC-9987: SQL Compare now reads clustered columnstore indexes on computed columns from script folders correctly
• SC-9983: SQL Compare can now modify security predicates in script folders correctly
• SC-9969: SQL Compare can now parse ALTER RESOURCE GOVERNOR RESET STATISTICS correctly
• SC-9985: Dependencies between user-defined types are now correctly read from a snapshot

13.2.1.5640 - March 1st 2018

Strapline

10 - Bug fixes

Engine API

• Removed the “caseSensitivity” parameters on Database.LoadFromDisk, which were being ignored by Compare Engine anyway
• SDT-711: Database.LoadFromDisk will use the snapshot’s collation when options are not specified

Fixes

• Bulk uninstaller improvements
• SC-9924: SQL Compare no longer creates multiple copies of history tables in scripts folders
• SC-9968: Improved performance displaying large text objects (over 1000 lines)
• SC-9928: SQL Compare command line switch Exclude filters out objects with Include:Identical switch on.
• SC-9920: Fixed a bug deploying ALTER INDEX DISABLE and REBUILD to scripts folders

13.2.0.5604 - February 20th 2018

FREQUENT UPDATES RELEASE

Strapline

20 - No insecure default logins 10 - Bug fixes

Engine API

• SQL generated for users mapped to SQL Server Authentication logins is now runnable on Azure SQL Database

Features

• SQL Compare now doesn’t create SQL Server Authentication logins

Fixes

• Some missing deployment dependencies are now listed more correctly. The actual deployment behaviour has not been changed.
• SC-9905: SQL Compare can now rebuild tables with row-level security policies and predicates on them.
• When a columnstore index is not supported in the target database version, the warning message now says whether it’s clustered
• SC-9949: SQL Compare now ignores the AddDatabaseUseStatement option when using the /empty2 command line switch.

13.1.11.5591 - February 13th 2018

Strapline

10 - Bug fixes

Engine API

• You no longer need to specify Options or ScriptDatabaseInformation for various Database operations: Register, CompareWith, LoadFromDisk, LoadFromStream, SaveToFolder. Unspecified Options will be Options.Default apart from SaveToFolder which uses Options.None to preserve old behaviour; unspecified ScriptDatabaseInformation will attempt to load from the xml file saved in the folder if reading, or use the database’s settings if writing. You may need a parameter specifier if you are e.g. providing ScriptDatabaseInformation but not Options.
• removed CaseSensitiveServer property, internal usages now use CaseSensitive
• changed return type of Database.GetObjectCollectionByType so it actually returns readonly as documented
• renamed / renamespaced some classes (Dependencies -> Model.Dependencies.DependenciesGraph, ObjectCollections -> Model.ObjectCollections, ObjectTypeHelper -> Model.ObjectTypeHelper)
• renamed some properties on Database (ScriptFolder -> ScriptFolderPath, ClrAssemblyDependencies -> ClrAssemblyDependenciesGraph, Dependencies -> DependenciesGraph)

Fixes

• SC-9919: SQL Compare doesn’t create IDENTITY columns on the history table when creating a temporal table from a scripts folder.
• SC-9836: SQL Compare now handles dependencies between user-defined type tables registered from live databases.
• SC-9893: SQL Compare now correctly parses the units in a SET TARGET_RECOVERY_TIME statement

13.1.10.5564 - January 30th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

SC-9857: SQL Compare now handles filegroups defined on a fulltext index.

Fixes

SC-9883: SQL Compare no longer displays a blank warning dialog when asking to overwrite the existing comparison report SC-9900: SQL Compare doesn’t duplicate index creation on history tables. SC-9909: SQL Compare can deploy history tables with the same name but different schema to their related temporal table. SC-9859: SQL Compare now deploys TEXTIMAGE_ON filegroup if it differs from the filegroup of the table. SC-9902: The interactive HTML comparison report now shows the server information

13.1.9.5540 - January 16th 2018

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9873: SQL Compare now handles indexes on persisted columns that rely on a function.
• SC-9888: SQL Compare now handles field modifications on history tables.

13.1.8.5525 - January 8th 2018

Strapline

30 - Indexes on temporal history tables

Features

• Integrates the Redgate bulk uninstaller
• SQL Compare now handles user defined and customized history tables for temporal tables, and will store all history tables in scripts folders.

13.1.7.5470 - December 11th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

13.1.6.5463 - December 5th 2017

Strapline

10 - Bug fixes

Fixes

• SC-9683: Fixed display of warning message text, which was invisible for some .NET 4.7 users
• SC-9400: Provided a mechanism to avoid stack overflow errors when parsing deeply nested elements in SQL.
• SC-9822: SQL Compare now deploys column constraint text containing chained function calls correctly.
• SC-9266: SQL Compare can now compare and deploy functions with NATIVE_COMPILATION
• SC-9811: SQL Compare now handles creation of clustered indexes on a user-defined history table.
• SC-9831: SQL Compare now handles method calls immediately following a COALESCE statement.
• SQL Compare Command Line now runs in 64-bit mode by default

13.1.5.5427 - November 27th 2017

Strapline

10 - Bug fixes

Fixes

• SC-9770: The SQL Compare parser now accepts NATIVE_COMPILATION syntax in CREATE FUNCTION statements.

13.1.4.5418 - November 20th 2017

Strapline

10 - Bug fixes

Engine API

• Table snapshots now contain the ChangeTrackingScriptSource property (SOC-9210/9211)

Fixes

• SC-9813: SQL Compare now respects the IgnorePermissions option for objects created in a deployment script.

13.1.3.5405 - November 14th 2017

Strapline

10 - Bug fixes

Fixes

• SC-9793: SQL Compare handles errors with a null stacktrace
• SC-9776: SQL Compare no longer attempts to deploy FULLTEXT indexes twice when CHANGE_TRACKING is enabled.
• SC-9798: SQL Compare again correctly identifies mapped tables over multiple schemas.
• SC-9802: SQL Compare doesn’t attempt to duplicate constraints between a history table and temporal table when reading from a scripts folder.
• SDC-2770: SQL Compare handles warnings when deleting a row, backing up a target or using multiple transactions.
• SDC-2764: Fixed a Windows Clipboard interaction bug when choosing which server to connect to

13.1.2.5327 - October 30th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

13.1.1.5299 - October 23rd 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9781: SQL Compare can deploy temporal tables from a scripts folder to a live database.

13.1.0.5287 - October 16th 2017

FREQUENT UPDATES RELEASE

Strapline

25 - Updated HTML Reports 10 - Bug fixes

Engine API

• Added a missing warning title that would have broken SOC

Features

• SQL Compare now generates a new style of HTML report, to match the reports produced by other Redgate products. For the command-line, this updates the -reporttype switch to include a new Html value. The Interactive and Simple values have been deprecated, and are now interpreted as being equivalent to the new Html value.

Fixes

• SC-8880: Scripts folders can now be in the root of a drive (as long as it is otherwise empty)
• SC-9775: On the command-line, in the absence of a -reporttype switch, SQL Compare now correctly uses the -report switch to infer the report type, based on the report file name extension. Supported extensions are html, htm, xls and xml.
• SC-9755: Deployment scripts are no longer saved with a double .sql extension.
• SC-9659: SQL Compare no longer tries to refresh schema bound views when deploying a change to an XML schema collection.

13.0.6.5248 - October 9th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• SC-9740: Ensured that warning messages correctly show a title next to the icon
• SC-9742: SQL Compare now handles rebuilds of tables which are both temporal and memory optimised.
• SC-9700: SQL Compare wraps the default values of DateTime and DateTime2 parameters defined in a stored procedure in single quotes.

Fixes

• SC-9739: Group header rows in the SQL diff viewer now display an equal or not-equal icon as required.
• SC-9709: Fixed an issue saving a backup snapshot when the option to save a snapshot is not selected.
• SC-9724: SQL Compare now doesn’t wrap $PARSER in square quotes when used within a table column.

13.0.5.5219 - October 2nd 2017

Strapline

10 - Bug fixes

Features

• SQL Compare now requires .NET 4.6.1
• Improved the installer UI for SQL Compare

Fixes

• SC-9727: Fixed an issue saving and reading scripts folders with graph tables
• SC-9700: SQL Compare wraps the default values of DateTime and DateTime2 parameters defined in a stored procedure in single quotes
• SC-9653: SQL Compare now supports the use of the non-reserved keyword MATCH, in the body of text objects.
• SC-9720/SC-9696: SQL Compare now handles comparison of whitespace and comments more consistently when the IgnoreWhitespace or IgnoreComments options are set.

13.0.4.5168 - September 25th 2017

Strapline

10 - Bug fixes

Fixes

• SC-9669: SQL Compare command line comparison no longer lists differences in temporal tables’ automatically generated columns, when static data is included in the comparison.

13.0.3.5144 - September 19th 2017

FREQUENT UPDATES RELEASE

Strapline

40 - Deployment logging 10 - Bug fixes

Features

• SQL Compare now supports altering SQL Server 2017 graph tables.
• SQL Compare now deploys SQL Server 2017 graph tables declared with AS NODE or AS EDGE
• SQL Compare now appends a logging statement at the end of the deployment script to log the deployment details to SQL Server Log in order for SQL Monitor to detect the deployment and mark it on the timeline for performance data. Note that this feature is currently in-trial and available for any edition of SQL Compare. However, it’ll soon only be available for SQL Toolbelt.

Fixes

• Row-level security policy block predicates are now correctly registered from on-premise live databases
• SQL Compare no longer offers Summary View option for text objects such as Stored Procedures and Functions.
• SC-9175: fix an issue where incorrect credentials could be used when registering, after typing server names into the connection dialog.

13.0.2.5109 - September 11th 2017

Strapline

40 - Password saving 30 - Open scripts in SSMS 2017 10 - Bug fixes

Features

• SQL Compare now lists SQL Server Management Studio 17 as a default script editor
• SQL Compare now remembers passwords in the Windows Credential Store, as well as the project file.

Fixes

• SC-9645: CREATE OR ALTER PROC is now scripted correctly
• SC-9548: SQL Compare will now correctly create fulltext indexes if the IgnoreTransaction option is selected
• SC-9685: SQL Compare now uses DEFAULT instead of the text of your default when coercing nulls to a column’s default value

13.0.1.5078 - September 4th 2017

Strapline

30 - History table indexes 10 - Bug fixes

Engine API

• SQL Compare Engine now targets .NET 4.0 instead of .NET 3.5
• SQL Compare Engine now writes to SQL Server Log in a structured way by default when a deployment succeeds. This behaviour can be turned off by passing the NoDeploymentLogging option.
• Licensing has been removed from SQL Compare Engine. You should no longer need a SQL Toolkit license to use SQL Compare Engine.

Features

• SQL Compare now supports customisation on history tables for temporal tables, such as customised indexes

Fixes

• SC-9662: The command line now displays your serial number correctly
• SC-9657: SQL Compare now filters whitespace and comments more consistently when the IgnoreComments option is set
• SC-9668: ALTER statements aren’t duplicated if ‘Add object existence checks’ option is set

13.0.0.5057 - August 29th 2017

FREQUENT UPDATES RELEASE

Strapline

30 - Temporal history retention 20 - DATABASE SCOPED CONFIGURATION syntax 10 - Bug fixes

Features

• SQL Compare now supports the HISTORY_RETENTION_PERIOD option on temporal tables
• The SQL Compare parser now accepts DATABASE SCOPED CONFIGURATION syntax.

12.4.12.5042 - August 24th 2017

Strapline

10 - Bug fixes

Fixes

• SQL Compare no longer fails to generate a deployment script when comparing 2 source control revisions that contain migration scripts.

12.4.11.5008 - August 21st 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9551: Snapshots now correctly save REVOKE permissions

12.4.10.4968 - August 8th 2017

Strapline

10 - Bug fixes

Fixes

fix: SC-9056: When all the differences in a project were previously selected then newly discovered differences will automatically be added to the selection. fix: SC-9532, SC-9537, SC-9538: The SQL Compare parser now accepts syntax for new SQL Graph, ALTER INDEX and STRING_AGG features in SQL Server 2017 fix: SC-9534: SQL Compare will create tables before schemabound functions to resolve dependencies fix: SC-9519: SQL Compare will no longer fail registration if the EXECUTE ANY EXTERNAL SCRIPT permission is present on a role object. fix: SC-9524: Fulltext changes to columns in views are now correctly displayed in the deployment wizard summary view fix: SC-9520: SQL Compare will now deploy DISABLED indexes to a scripts folder

12.4.9.4945 - July 31st 2017

Strapline

10 - Bug fixes

Features

• SC-9335: SQL Compare now supports Azure Active Directory authentication with integrated and password authentication methods. These options are available in the ‘Authentication’ dropdown in the ‘Database’ section of the ‘Edit project’ window. Note that this feature requires .NET 4.6 and adalsql.dll to be installed; see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure#configure-your-client-computers for more details

Fixes

• SC-9518: The layout of the backup data source grid in the new project window has been fixed
• SC-9526: The SQL Compare parser now accepts parentheses around identifiers in a CREATE FULLTEXT INDEX statement

12.4.8.4926 - July 26th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9521: Deploying a fulltext index to a view no longer causes a crash in the deployment wizard.
• SC-9267, SC-9296, SOC-8837: Fixed a bug where for some machines database registration could fail with the message “An unexpected error was encountered while querying the database system tables…” (with the original error message “String was not recognized as a valid DateTime”)
• SC-9501: Spurious TEXTIMAGE_ON clauses are no longer appended to tables with computed columns registered from scripts folders
• SC-9516: SQL Compare now handles dependencies between fulltext indexes and other indexes correctly
• SC-9513: Manual column mappings that would have been auto-mapped are now persisted

12.4.7.4905 - July 13th 2017

Strapline

20 - Updated summary view

Features

• All comparable objects are now supported in the summary view! For text differences, SQL Compare will show the first actual difference between the two objects, as well as other properties such as permissions and extended properties.
• Summary view: Improved difference highlighting.

Fixes

• Filters checked into source control data sources are now applied by default.
• SC-9509: The ‘Generate comparison results report’ menu item will now be enabled after comparing a project from the ‘My projects’ window using the ‘Compare now’ option
• SC-9514: Switching deployment direction will no longer cause the currently selected object to be deselected
• SC-9512: SQL Compare will now report info messages (eg PRINT statements) when running a deployment

12.4.6.4860 - July 4th 2017

FREQUENT UPDATES RELEASE

Strapline

20 - Summary view functions and views

Features

• Summary view: Updated UI to improve horizontal scanning. Added colors to indicate additions and deletions. Improved display of newline characters.
• Functions and views are now supported in the summary view! SQL Compare will show the first actual difference between the text of two objects, as well as other properties such as permissions and extended properties.

Fixes

• SC-9504: SQL Compare will now correctly treat multiplication/division operations as having a higher precendence than bitwise operations in the parser
• SC-9471: SQL Compare can now write constraints with an AT TIME ZONE clause correctly
• SC-9507: SQL Compare will no longer script out an empty ALTER SEQUENCE statement when the only extended properties are different between the respective sequences.

12.4.5.4811 - June 28th 2017

FREQUENT UPDATES RELEASE

Strapline

20 - Summary view for stored procedures

Features

• The text size in the summary view is now customizable
• The SQL diff viewer now uses the red/green highlighting commonly found in other diff tools.
• Stored procedures are now supported in the summary view! SQL Compare will show the first actual difference between the text of two stored procedures, as well as other properties such as permissions and extended properties.

Fixes

• SC-9486: The deployment summary now lists all planned actions on loading the summary tab.
• SC-9508: The SQL diff view is no longer inverted when switching deployment direction.
• SC-9496: Functions which depend on a UDT will no longer compare different when the function is read from a scripts folder and the UDT is missing from the scripts folder

12.4.4.4771 - June 21st 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Summary view

The summary view will now display all key columns that are different between two indexes, rather than just the first different column. The summary view diff highlighting has also been improved to only perform highlighting on individual characters where it makes sense for the type of property being compared.

Fixes

• SC-9421: Improved difference highlighting in the summary tab.
• Fixed an issue in SQL Compare which could cause certain parts of the SQL view to be spread over multiple newlines when matched with an empty line on the other side of the comparison
• SC-9497: Improved Summary view display of key columns on indexes

12.4.3.4752 - June 20th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

SQL view

When the ‘Force column order’ option is not set, columns in the target SQL view will now be reordered to match those in the source SQL in order to provide a more easily readable diff.

Summary view

We’ve made display of column datatypes more concise in the summary view, and the layout of columns will now take column mappings into account.

Fixes

• SC-9494: SQL Compare will no longer truncate extra long warnings in the deployment wizard
• SC-9184: SQL Compare now shows if an index is disabled on the SQL view, therefore showing differences that may have previously been visually hidden.
• SC-9419: Summary view results for table columns will now take column mappings into account.
• SC-9483: SQL Compare now remembers TEXTIMAGE_ON settings on a table in a non-default filegroup and doesn’t default TEXTIMAGE_ON setting when deploying.
• SQL Compare will no longer fail the comparison when using the SQL Source Control data source if there is an issue loading the source controlled filter file.
• SC-9493: SQL Compare now correctly reads fields from indexes on a filetable when reading from a scripts folder
• SC-9479: In the summary tab, the display of columns that differ in their datatype has been made more concise
• SC-9411, SC-9180, SC-9397: SQL Compare should now correctly preserve different newline characters in user-generated SQL

12.4.2.4681 - June 7th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Summary view

We’ve increased the default text size, removed some extra whitespace around the top row of the results and added scrollbars to make the summary view easier to use. The summary view tab will also now stay selected when switching between different objects in the comparison.

Fixes

• SC-9475: Improved interactions around the database dropdown in the Edit Project dialog: in particular, hitting backspace will no longer clear the database name entirely. As part of this work we’ve removed the feature where entering a database name for a database that had the SQLSourceControl Database Revision extended property set would display the value of this extended property in the UI. This extended property is no longer set by SQL Source Control and the feature ended up causing a disproportionate amount of complexity for information that it provided.
• SC-9437: Fixed a bug which could cause some rows in the My Projects dialog to not render correctly when there were some invalid project files in the displayed folder
• SC-9457: SQL Compare now automatically applies the default filter (Filter.scpf) when registering from scripts folders or source control.
• Drop and recreate PERSISTED computed columns when changes are found, rather than rebuilding their table.
• SC-9455: SQL Compare now produces the correct existence check when renaming a table and moving it between schemas.
• SC-9403: SQL Compare no longer leaves duplicate NOCHECK statements when deploying to scripts folders
• SC-9271: When an error occurs updating or dropping an extended property the current transaction will now be rolled back

12.4.1.4639 - May 30th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• The authentication type for databases (Windows/SQL Server) is now specified as a dropdown. This allows more authentication types to be added in the future.

Fixes

• SC-9404: Fixed a bug which prevented the saved sort order in the My Projects dialog from being applied correctly
• SC-9456: Fixed some high-DPI display issues in the deployment wizard ‘Deployment method’ settings that occurred when the windows UI scale was set to 250% or greater
• SC-9439: The “Edit selected file” button on the “Error parsing scripts” dialog will now correctly launch the selected editor
• SC-9271: When an error occurs updating or dropping an extended property the current transaction will now be rolled back
• SC-9429: When rebuilding a temporal table, SQL Compare no longer scripts out the HIDDEN property or default constraints on the new history table.
• SC-9443: SQL Compare now correctly scripts out DATA_COMPRESSION on temporal and memory-optimized tables
• SC-9476: SQL Compare now handles index drops correctly while disabling SYSTEM_VERISONING.
• SC-9474: Fixed some high-DPI display issues in the deployment wizard title bar

12.4.0.4551 - May 16th 2017

FREQUENT UPDATES RELEASE

Strapline

50 - Difference summaries 20 - CREATE OR ALTER syntax 10 - Bug fixes

Features

• Added a summary view which will semantically explain how database objects differ
• SC-9401: SQL Compare now accepts the ‘CREATE OR ALTER’ syntax introduced in SQL Server 2016 SP1

Fixes

• SC-9441: SQL Compare now accepts SET syntax where a property on a CLR user-defined type is being set
• SC-9440: SQL Compare can now register multiple XML indexes on a single table with several selective XML indexes per index

12.3.3.4490 - May 8th 2017

Strapline

10 - Bug fixes

Features

• The “My Projects” window can now be opened from the toolbar

Fixes

• When using the SQL Source Control data source and comparing custom-linked databases, the revision fields are now correctly disabled.
• SC-9399: When using the SQL Source Control data source, progress updates will now be displayed while the requested revision of the scripts folder is being checked out.
• Changes to a comparison report’s name will now be correctly used if the report is generated while the “name” field still has focus.
• SC-9433: Fixed a bug which could prevent the sqlcompare.exe commandline from recognising /options:IgnoreIndexes in some deployment cases.

12.3.2.4426 - April 26th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9392: Fixed an issue where filters could be loaded into the filter panel multiple times.
• SC-9393: GENERATED ALWAYS columns can now be added to tables even when the ‘use object existence checks’ option is set
• SC-9363: Fixed a bug where SQL Compare could fail to create a filtered index if another object had been created with SET ANSI_NULLS OFF earlier in the deployment script

12.3.1.4383 - April 12th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• Fixed a silent crash on start up that could occur when upgrading from SQL Compare 12.2.3 or 12.2.4

12.3.0.4373 - April 10th 2017

FREQUENT UPDATES RELEASE

Strapline

60 - SQL Server vNext 10 - Bug fixes

Features

• Interactive HTML reports now include the last modification date of each object
• SQL Compare can now register SQL Server vNext backups and scripts folders

Fixes

• SDC-2222: Changing the comparison direction in Data Compare no longer triggers a recomparison
• SC-9339: The size of the My Projects dialog is now saved between sessions

12.2.4.4299 - March 30th 2017

FREQUENT UPDATES RELEASE

Strapline

50 - Git revision support 10 - Bug fixes

Features

• SC-9066: It is now possible to compare to a historical git revision (Requires SQL Source Control 5.5.4 or later)

Fixes

• Fixed an issue where it was possible to select revision history for version control systems that do not support revision history
• SC-9374, SC-9376: Choosing ‘HEAD’ as the source control revision no longer causes a ‘Value cannot be null’ error in the UI or command line
• SC-9357: SQL Server 2016’s MIN_GRANT_PERCENT and MAX_GRANT_PERCENT syntax is now recognized
• SC-9365: SQL Server 2016’s OPTION (USE HINT(..)) syntax is now recognized

12.2.3.4239 - March 27th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• SQL Compare now has an IgnorePerformanceIndexes option to ignore all indexes except primary keys and unique constraints.

Fixes

• SC-9208: When loading snapshots, the project’s case sensitivity option is now used (rather than the one stored in the snapshot)
• SC-9349: When a deployment adds GENERATED ALWAYS columns to a table, PERIOD FOR SYSTEM_TIME is now set on the table too
• SC-9368: log messages containing curly braces (e.g. if SQL objects have curly braces in their name) no longer cause FormatException to be thrown

12.2.2.4140 - March 13th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Features

• SC-9338: The My Projects dialog will now remember the previous sort ordering

Fixes

• SC-9271: Errors thrown by sp_addextendedproperty are now handled correctly in deployment scripts
• SC-3932: Interactive HTML Reports now escape forward slashes in object names and descriptions
• SC-9204: Filenames are no longer truncated in the deployment wizard when updating a scripts folder
• SC-8944: Improved the title bars of various dialogs in high DPI mode

12.2.1.4077 - March 6th 2017

Strapline

10 - Bug fixes

Features

• When trialling SQL Compare you now be asked to create a Redgate ID. Please see https://www.red-gate.com/user-licensing for details.

Fixes

• SC-9177: Preserve changes to column widths in the My Projects dialog

12.2.0.4045 - February 22nd 2017

FREQUENT UPDATES RELEASE

Strapline

50 - Temporal tables 10 - Bug fixes

Features

• SQL Compare now supports temporal tables on SQL Server 2016.

Fixes

• SC-9207: Fixed a bug where the end of a temporal SELECT statement would disappear from a textual object definition
• SC-9274: Roles can now contain roles having the same name as a user
• SC-9265: Fix an issue that the Deploy button could be incorrectly enabled or disabled
• SC-9178: Made the Create Database dialog more responsive

12.1.6.3982 - February 13th 2017

FREQUENT UPDATES RELEASE

12.1.5.3927 - February 6th 2017

FREQUENT UPDATES RELEASE

Strapline

50 - Ignore data in timestamp columns

Features

• Data in timestamp columns is now ignored when you use the /Include:StaticData switch on the command line.

Fixes

• SC-9197: Support registering databases with users that have the permission ALTER ANY EXTERNAL DATA SOURCE
• SC-9168: Whitespace differences no longer shown in the differences pane, when the “Ignore white space” option is used.
• SC-9209: Fix sorting of the Last modified columns in the main differences grid
• SC-9166: The deployment wizard now picks up changes to backup settings made while deploying
• SC-9171: Fixed a parser crash reading BEGIN DIALOG CONVERSATION statements
• RGC-255: Removed an issue that could cause minute-long delays during startup

12.1.4.3873 - January 17th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9153: SQL Compare will no longer display an error when loading a project using SQL authentication where the ‘Save Password’ box has not been checked.
• SC-9188: Improved highlighting of the SQL diff view when case sensitive or ignoring whitespace
• SC-9190: Fixed some checkboxes which were invisible in some cases
• SC-9162: Fixed a parser crash caused by an ambiguity that could occur when a SELECT .. from OPENQUERY statement was followed by a MERGE statement

Features

• SC-4600: SQL Compare will now try to disable and enable indexes and foreign keys when appropriate

12.1.3.3849 - January 16th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9176: SQL Compare now uses a shorter date format in the open project dialog
• SC-9174: fix incorrect icons and text in generated comparison report when deploying right-to-left in SQL Compare
• Fixed an issue where we couldn’t add/remove “WITH ENCRYPTION” in some cases

12.1.2.3823 - January 9th 2017

FREQUENT UPDATES RELEASE

Strapline

60 - SSMS v17.0 RC1 plugin 50 - SQL Server on Linux

Features

• SQL Server vNext on Linux is now supported.
• SQL Compare SSMS extension now supports latest version (v17.0 RC1) of SQL Server Management Studio

Fixes

• SC-9154: Object existence checks for bound defaults are now written out correctly
• SC-9160: SQL Compare now no longer allows showing multiple create database dialogs
• Fixed a bug where swapping databases in the Edit Project dialog could cause SQL Source Control revision numbers to be associated with the wrong database

12.1.1.3793 - January 4th 2017

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9167: The ignore white space option now correctly ignores white space in comments of textual objects
• SC-9159: Fixed a case where SQL Compare could crash while registering inline CLUSTERED COLUMNSTORE definitions in a CREATE TABLE statement from a scripts folder
• SC-9058: Improved support for AT TIME ZONE syntax
• SC-9147: SQL Compare will now recreate an index after dropping it due to changing an underlying field when the Ignore indexes option is set and the index only exists in the target database
• SC-9158: SQL Compare now accepts OPENJSON calls with arbitrary expressions as the json parameter
• SC-9155: SQL Compare will no longer check for differences in activation properties on queues (EXECUTE AS, MAX READERS, etc) if an activation procedure is not set
• SC-9157: Improved the responsiveness of SQL Compare when selecting items to deploy

12.1.0.3760 - December 19th 2016

Strapline

10 - Bug fixes

Fixes

• SC-2186, SC-3890, SC-3975, SC-4993, SC-9147: SQL Compare will now recreate an index after dropping it due to changing an underlying field when the Ignore indexes option is set
• SC-9149: SQL Compare now accepts the WAIT_AT_LOW_PRIORITY option for ALTER TABLE SWITCH PARTITION statements
• SC-9146: SQL Compare now correctly requires professional edition to use source control data sources.
• SC-9150: The new My Projects window will no longer have its own entry in the taskbar to prevent some bugs with modal dialogs being accessed in the wrong order
• SC-9156: The new My Projects dialog will now correctly load projects which specify a SQL Source Control data source

12.0.40.3714 - December 6th 2016

FREQUENT UPDATES RELEASE

Strapline

70 - My Projects dialog 20 - Yellow diff 10 - Bug fixes

Fixes

• SC-9111: SQL Compare no longer attempts to fetch the SQL Source Control revision number for a database if it is not in the list of databases for that server. This fixes a bug where typing in the database name would cause repeated failed login attempts.
• SC-9136: SQL Compare now correctly handles stored procedure parameters with negative defaults
• SC-9130: Fix a bug where custom filters were not always saved correctly
• SC-8950: SQL Compare now accepts /scriptsfolderxml1 and /scriptsfolderxml2 switches (to give different source control information for each database)

Features

• SQL Compare has a new ‘my projects’ dialog accessible from the File menu. The new dialog can also be made to show by default at startup.
• The diff viewer now uses yellow highlighting rather than blue

12.0.39.3632 - November 23rd 2016

FREQUENT UPDATES RELEASE

Strapline

30 - new Azure event types 30 - OPENJSON parsing 10 - Bug fixes

Features

• SQL Compare now correctly parses SELECT statements using the FROM OPENJSON (…) WITH syntax
• Updated SQL Compare with new event types introduced in a recent Azure SQL Database update

Fixes

• SC-9134: SQL Compare no longer crashes when comparing windows users that differ in case when the case-sensitive object definition option is set
• SC-9092: SQL Compare will no longer display progress values greater than 100% during registration in the mappings UI
• SC-9120: SQL Compare will no longer highlight whitespace differences in the difference pane if the Ignore white space option is set
• SOC-8087: Using migrations no longer causes a crash if git is not installed

12.0.38.3582 - November 15th 2016

FREQUENT UPDATES RELEASE

Strapline

30 - EXTERNAL RESOURCE POOL syntax 30 - CONTAINMENT syntax 10 - Bug fixes

Features

• SQL Compare now supports create, alter and drop EXTERNAL RESOURCE POOL syntax in SQL Server 2016
• SQL Compare now supports the CONTAINMENT = NONE/PARTIAL syntax in SQL Server 2016

Fixes

• SC-9117: SQL Compare no longer crashes when several windows users with the same name but different domain names exist in the same database
• SC-9112: SQL Compare will now successfully compare user defined types named “TableType” between a database and script folder.
• SC-9090: SQL Compare now detects the dependency between a computed column in a table and the function
• RGC-248: Licensing dialogs are more usable in High DPI mode

12.0.37.3561 - November 10th 2016

FREQUENT UPDATES RELEASE

Strapline

50 - Column automapping option 10 - Bug fixes

Features

• SQL Compare now has a project-level option, NoAutoColumnMapping, to disable automatic mapping of similarly named columns in mapped tables.

Fixes

• Fixed sorting of “last modified date” column
• SDC-2225: Improved cleanup of temporary files when deploying to scripts folders

12.0.36.3534 - November 7th 2016

FREQUENT UPDATES RELEASE

Strapline

40 - Better update notifications 30 - DATABASE SCOPED CREDENTIAL syntax 30 - ALLOW_ENCRYPTED_VALUE_MODIFICATIONS syntax 30 - Stretch table syntax 30 - DROP IF EXISTS syntax 10 - Bug fixes

Features

• Improved Check for updates UI - available updates are now a lot more obvious, there are more options for ignoring updates and the installation process has been streamlined
• SQL Compare now supports the DATABASE SCOPED CREDENTIAL syntax in SQL Server 2016
• SQL Compare now supports the ALLOW_ENCRYPTED_VALUE_MODIFICATIONS syntax creating users in SQL Server 2016
• SQL Compare now supports syntax to create stretch tables in SQL Server 2016
• SQL Compare now supports the DROP IF EXISTS syntax for dropping objects in SQL Server 2016

Fixes

• SC-9089: It is now possible to create databases on Azure SQL Database using SQL Compare.
• SC-8123: Creating a database on an Azure server no longer hits a timeout.

12.0.35.3485 - October 31st 2016

FREQUENT UPDATES RELEASE

Strapline

70 - Last modified date 30 - FILTER_PREDICATE syntax 30 - PARTITIONS truncating syntax 10 - Bug fixes

Features

• For tables, views, functions and stored procedures, the differences grid now shows the last modified date
• SQL Compare now records the last modification date for tables, views, functions and stored procedures
• SQL Compare now supports the FILTER_PREDICATE keyword altering tables on stretch databases
• SQL Compare now supports the SQL Server 2016 syntax for truncating a table with the PARTITIONS option

Fixes

• SC-9069: Fixed a problem when registering a backup in 2K compatibility mode

12.0.34.3467 - October 26th 2016

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-9071: Avoided a possible crash when calculating table drops
• SC-9062: Fixed an issue where SQL Compare could forget a selected revision number for a SQL Source Control data source when editing an already-compared project
• SC-9061: SQL Compare now adds the SQL Source Control revision number to the deployment script comment header, if available
• SC-9085: Fixed a bug where spaces could be appended to the end of multiline statements when saving a deployment script to a file
• SC-9060: SQL Compare now allows arbitrary revision numbers to be typed into the SQL Source Control data source UI.
• SC-9088: Typing in the database in the Edit Project dialog will now scroll to that database in the dropdown
• SC-9086: SQL Compare no longer shows region marker comments as different in the text diff when there are other differences in that region

12.0.33.3389 - October 17th 2016

Strapline

10 - Bug fixes

Fixes

• SC-7709: Improved usability on high DPI monitors
• SC-8933, SC-7963, SC-9031: Errors or inconsistencies detected during registration are no longer incorrectly reported with the message “a duplicate object name has been found”. Instead, more helpful descriptions of the errors are given.
• SC-9053: sqlcompare.exe will now correctly fail with exit code 63 (databases identical) if the only changes to deploy are migration scripts and IgnoreMigrationScripts is specified as an option
• SC-9057: Fixed a case where objects could be sorted inconsistently when sorting by the left object name
• SC-9058: SQL Compare now accepts the [date] AT TIME ZONE [timezone] syntax
• SC-9059: Fixed a case where fetching the list of databases would fail when the server name contained custom connection string parameters
• SC-9065: Fixed a crash that could occur when comparing a SQL user to a Windows user

12.0.32.3340 - October 10th 2016

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-8716: Indexes on a column are not recreated when the only change to the column is the modification of a DEFAULT constraint
• SC-8894: Fix exception in the deployment wizard when displaying messages not linked to objects.
• SC-8998: SQL Compare now restores the main window position and size more reliably
• SC-8959: Fixed an issue where SQL Compare would attempt to connect with the wrong credentials while loading the SQL Source Control revision number from a database
• SC-9041: Allow saving and opening projects with automatically mapped tables and columns
• SC-9037: Double clicking on the comparison banner will now change the deployment direction
• SC-9045: No longer throw an exception when mapping previously unmapped columns
• SC-8997: The deployment wizard button is now disabled if there are no differences to deploy
• SC-9026: Fix exception on using the /out flag in the command line.
• SC-9021: Projects created by the SSMS integration pack will now load your default options
• SC-9038: Fixed an issue where switching the deployment direction could forget some object selections
• SDC-2210: The mappings UI now supports selecting or deselecting multiple rows using the mouse (previously this would only work with the spacebar)
• SDC-2211: Some of the table layouts in the Edit Project dialog have been tweaked to make better use of space
• SDC-2212: The UI now shows a spinny while generating a deployment script
• SDC-2213: The UI now shows the deployment script in black while generating the syntax highlighting
• SC-9044: Improved error handling on open file dialogs when a default directory can not be found
• Comparison summary dividers and tooltips now show the full server and database name

12.0.31.3232 - October 3rd 2016

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-8702: Users named after Windows principals are now equal even if their domains are different
• SC-8409: Fixed a crash when failing to fetch encrypted object text
• SC-9003: Correctly identify differences in stored procedures with comments between create statement and object name
• SC-8965: Include existence checks for roles in the deployment script, when “Add object existence check” is specified.
• SC-9017: Show dropped items separately in the summary pane of the deployment wizard
• SC-8990: Fixed a crash when failing to list SQL Server instances
• SC-9000: SQL Compare now applies filter criteria when generating reports

12.0.30.3199 - September 27th 2016

Strapline

10 - Bug fixes

Fixes

• SC-7709: Improved the appearance of the title bar in high DPI mode
• SC-9897: Fixed a crash when displaying a partially-formed source control location.
• Fixed multiple issues saving and loading custom filters.
• SC-9009: Textual objects containing empty lines on one side of the comparison will no longer cause errors in the diff viewer

12.0.29.3182 - September 22nd 2016

FREQUENT UPDATES RELEASE

Strapline

10 - Bug fixes

Fixes

• SC-8990: Exceptions occuring during SQL Server instance discovery will no longer bubble up into the UI
• SC-8993: Fixed a bug which would cause Compare to show dependencies in the deployment wizard which weren’t linked to deployable differences
• SC-8988: Command line now uses specified options when making snapshots
• SC-8995: Allow source control as a source or target when using the command line
• SDC-2195: Fixed a crash in the project config dialog when right-clicking in the database dropdown
• SC-9004: Custom connection string properties can now be passed by adding them to the server name on the connection dialog
• SC-8955: SQL Compare now handles exceptions that occur while trying to set clipboard text while another application is locking the clipboard

12.0.28.3138 - September 19th 2016

• SC-8989: Fixed filter checkboxes for projects loaded using the SSMS Integration Pack
• SC-8939: Use fully qualified name of table types columns in table definitions

12.0.27.3125 - September 15th 2016

• SC-8953: Projects loaded using the SSMS Integration Pack now load with the correct ‘Nothing excluded’ filter
• The default file name for snapshots taken in the deployment wizard now contains a timestamp

12.0.26.3104 - September 15th 2016

FREQUENT UPDATES RELEASE * SC-8951: Prevented the object diff view from jumping around when selecting differences at the end of the list * SC-8948: When renaming a table and a column in the same deployment the correct existence check will now be written in the deployment script.

12.0.25.3064 - September 13th 2016

FREQUENT UPDATES RELEASE * SDC-2193, SC-8964, SC-8973: SQL Compare now correctly ignores whitespace in comments when “ignore whitespace” option is used * SC-8970: Fixed spelling of “deployment” in the “Don’t use transactions” option description

12.0.24.3012 - August 25th 2016

FREQUENT UPDATES RELEASE

Fixes

• SC-8936: Fix a bug where in the deployment wizard where the name and path of the sync script were being ignored.
• SC-8935: Add a timestamp to the filename for sync scripts to match the behaviour of SQL Compare 11.
• SC-8930: Make schema table mapping view display ‘full’ and ‘partial’ correctly
• SC-8910: Fix a rare crash while loading the schema to edit the mappings

12.0.23.2976 - August 25th 2016

FREQUENT UPDATES RELEASE

Fixes

• SC-8922 Fixed viewing/saving/copying the deployment script when a text object uses nonstandard line endings
• SC-5275: Added keyboard support to the table mapping grids
• SDC-2181: The deployment script comment header will now show the UI version instead of the compare engine version.
• SC-8907: Exclude spammy log messages caused by attempts to resolve resource assemblies
• SC-8928: The mappings step for a comparison no longer causes the UI to hang in a database with many tables
• SC-8642: Recently used projects are now added to the program jumplist in Windows 10

12.0.22.2910 - August 22nd 2016

FREQUENT UPDATES RELEASE

Fixes

• SC-8731: Fixed a graphical glitch in the Create snapshot dialog when backups were used as a data source but no backup files were selected
• SDC-2174: Support changing comparison direction on comparisons involving backup data sources
• SC-8620: Long error messages will no longer cause the “more details” dialog to be taller than your primary monitor
• SDC-2124, SDC-2125: Show ellipsis correctly when column or table name get too long in mappings window

12.0.21.2819 - August 16th 2016

Fixes

• SC-8235: Can now search and paste paths when opening folder locations
• SC-8733: Display a message when there are no deployment warnings
• SC-8724: Display folder location rather than database name in the summary line of source control dialog

12.0.20.2791 - August 11th 2016

Fixes

• SC-8831: SQL Compare now understands the LINENO statement.

12.0.19.2758 - August 9th 2016

Fixes

• SC-8900: Databases are now referred to as ‘source’/‘target’ rather than ‘first’/‘second’ throughout the application.
• SC-8904: Prevented an undeployable difference that could occur when a stored procedure was created with a lowercase CREATE keyword.
• SC-8505: The “Ignore WITH element order” option will now correctly ignore the order of items in a WITH clause.
• SC-8099: Non-breaking spaces are now ignored in extended property values when the “Ignore whitespace” option is on.
• SC-8899: When changing deployment direction on a new project, any project open will not also change deployment direction.
• SC-8724: Display folder location rather than database name in the summary line of source control dialog

12.0.18.2723 - August 5th 2016

Fixes

• SC-8898: Fixed a bug that prevented swapping direction in the Edit Project window in some cases where a comparison had not yet been performed.

12.0.17.2708 - August 4th 2016

Fixes

• SC-8732: The ‘enter’ key now searches in the find box in the deployment script view.

12.0.16.2688 - August 3rd 2016

Fixes

• SC-8891, SC-8892: SQL Compare will no longer treat compatibility level 80 as a 2000 database when checking for deprecated versions.
• SC-8886: Open project dialog can now read both Compare and Data Compare project files.
• SC-8413: Fixed an error generating a deployment script when your repository contains migration scripts.
• Additional logging for errors during deployment when your repository contains migration scripts.
• SC-8866: The progress dialog now gives a better indication of exactly which subtask failed, if any.

12.0.15.2659 - August 2nd 2016

Fixes

• SC-8880: Fixed a crash when copying/moving scripts folders in the connection dialog.

12.0.14.2614 - July 28th 2016

Features

• SQL Server 2000 databases are no longer supported.
• Migrations v2 is no longer supported

Fixes

• SC-8840: Fixed a bug where trials were reported as standard edition, causing the commandline to be unavailable
• SC-8838: The ‘Ignore migration scripts for databases’ option will now correctly disable SQL Source Control 5 migrations
• SC-4381: SQL Compare now displays nested multiline comments properly in the difference pane
• SC-8820: ‘Recently used’ lists will now store up to ten items.
• SC-8854: Prevented a crash that could occur when registering a scripts folder containing a function with a complex series of aliases.
• SC-8042: Add check to avoid putting default permission for user defined types twice in the permission list
• SC-8850: The state of the ‘deploy all dependencies’ checkbox in the deployment wizard is now persisted (on a per-project basis).

12.0.12.2546 - July 22nd 2016

Fixes

• SC-8809: Mappings work consistently when deploying in either direction
• SC-8722: SQL Compare now registers permissions on sequence objects from scripts folders.
• SC-8832: Excluding dependencies in the deployment wizard now works as expected
• SC-8830: The deployment wizard will no longer crash when a difference matching an object changed by the deployment script cannot be found This build also rolls up fixes from recent Compare v11 versions:
• SC-8668: SQL Compare no longer generates incorrect creation script for objects using WITH ENCRYPTION option when AS keyword not specified
• SC-8421: Dependencies now correctly calculated from ALTER SCHEMA statements.
• SC-8777: Data compression differences now picked up when Ignore filegroup, partition scheme and partition function option used
• SC-8735: Default values for parameters of type BINARY can now be registered from live databases
• SC-8667: Default parameters no longer cause an overflow exception for large (>3.4E38) values
• SC-4447: Default parameters no longer cause an overflow exception for large (>3.4E38) values
• SC-8702: Users are now regarded as equal if they are Windows principals on different domains
• SC-8353: Compare no longer forgets to add columns when rebuilding a fulltext index on a view
• SC-8671: Compare now correctly scripts out computed columns that call functions with DEFAULT parameters
• SC-8665, SC-8392: System functions added in Sql Server 2016 are no longer escaped when deploying to a scripts folder
• SC-8632: SQL Compare no longer treats change_tracking_current_version as a column name in constraints
• SQL Compare now detects that a table is dependent on a function when the function is used in a check constraint

12.0.10.2453 - July 15th, 2016

Fixes

• All users are now eligible for a new 14 day trial

12.0.9.2436 - July 14th 2016

Fixes

• SC-8791: Mapping two tables in the same schema when that schema is unmapped now keeps the mapping in the comparison
• SC-8803: Mapping two differently named tables when a schema is unmapped now keeps the mapping in the comparison

12.0.8.2363 - July 12th 2016

Features

• The product switcher has returned to Compare 12
• New login based licensing: see https://www.red-gate.com/user-licensing for more details

Fixes

• SC-8763: The deployment progress dialog no longer sometimes fails to report successful completion.

12.0.7.2257 - June 30th 2016

Fixes

• SC-8771: The UI executable is now called RedGate.SQLCompare.UI.exe as it was in 11.0
• SC-8695: Speed up comparison when switching deployment direction
• SC-8752: The dependencies page in the deployment wizard should now correctly refresh results when different objects are selected

12.0.6.2193 - June 24th 2016

Fixes

• SC-8680: The application no longer has graphical errors when used in high DPI modes
• SC-8706: Source and target databases are correctly labelled in the deployment wizard when reversing deployment direction
• SC-8758: The user is no longer double-prompted for confirmation when saving a deployment script to disk will overwrite an existing file.

12.0.5.2129 - June 20th 2016

Fixes

• Support for obsolete migrations versions (original and v2) has been removed from the command line.
• SC-8611: Cancelling the connection dialog window no longer results in mappings being saved

12.0.4.2107 - June 16th 2016

Fixes

• SC-8694: Deployment scripts now contain consistent line endings
• SC-8698: Copying a deployment script to the clipboard now result in the correct line endings
• SC-8611: Changes to deployment options are now saved when a comparison is not required
• SC-8611: Cancelling the connection dialog window no longer results in mappings being saved
• SC-8728: Make save, copy and search bar visible when loading deployment summary
• SC-4961: Moved the logging options to the Help menu instead of the system menu

12.0.3.2043 - June 10th 2016

Fixes

• SC-8686: Performance improvements for dependencies in the deployment wizard
• SC-8717: More fixes for SQL Source Control detection where the list of installed applications is problematic
• SDC-2140: The unmapped objects section of the mappings UI is now expanded by default
• SC-8715: Improving font consistency: consolidating on Segoe UI
• SC-8721: SSMS 2016 has been added to the list of possible external editors

12.0.2.2016 - June 9th 2016

Fixes

• SC-8610: ‘Save project before closing’ dialog will no longer prompt for a filename if one is already known
• SC-8688: SQL Compare should no longer interfere with the taskbar auto-hide
• SC-8692: Text and interactive help fixes for the “Error parsing scripts” dialog
• SC-8693: SQL Compare should now correctly update the selected sql editor when changed from the deployment wizard
• SC-8655: Use latest icon for SQL Source Control
• SC-8684: Make SQL Source Control detection more robust when used as a data source
• Some high-DPI improvements for the differences and filter UIs

12.0.1.1977 - June 6th 2016

Fixes

• Minor tweaks to interactive help and database refresh buttons
• More validation and remote folder browser for backup options in the deployment wizard

12.0.1.1964 - June 3rd 2016

This is a beta release of SQL Compare 12, which brings a major UI refresh alongside support for major SQL Server 2016 features.

11.6.11.2463 - July 18th 2016

Fixes

• SC-8668: SQL Compare no longer generates incorrect creation script for objects using WITH ENCRYPTION option when AS keyword not specified
• SC-8421: Dependencies now correctly calculated from ALTER SCHEMA statements.

11.6.10.2352 - July 11th 2016

Fixes

• SC-8777: Data compression differences now picked up when Ignore filegroup, partition scheme and partition function option used

11.6.9.2306 - July 6th 2016

Fixes

• SC-8735: Default values for parameters of type BINARY can now be registered from live databases

11.6.7.2123 - June 20th 2016

Fixes

• SC-4447: Default parameters no longer cause an overflow exception for large (>3.4E38) values

11.6.6.2057 - June 13th 2016

Fixes

• SC-8353: Compare no longer forgets to add columns when rebuilding a fulltext index on a view
• SC-8671: Compare now correctly scripts out computed columns that call functions with DEFAULT parameters
• SC-8702: Users are now regarded as equal if they are Windows principals on different domains

11.6.5.1976 - June 6th 2016

Fixes

• SC-8665, SC-8392: System functions added in Sql Server 2016 are no longer escaped when deploying to a scripts folder

11.6.3.1926 - June 1st 2016

Fixes

• SQL Compare now detects that a table is dependent on a function when the function is used in a check constraint

11.6.2.1799 - May 23rd 2016

Fixes

• SC-8632: SQL Compare no longer treats change_tracking_current_version as a column name in constraints

11.6.1.1686 - May 16th 2016

Fixes

• SDC-1356: Fixes a crash related to extremely large deployment scripts
• SOC-5919: SQL Compare now respects options (eg ‘Case sensitive object definition’ and ‘Ignore whitespace’) when comparing extended property string values

11.6.0.1493 - May 9th 2016

Features

• Now deploys migations created in SQL Source Control 5 Release Candidate.
• Migrations created with the SQL Source Control 5 Beta are no longer supported

Fixes

• SC-8060: SQL Compare no longer fails to register scripts folders containing DML triggers that reference an XML schema collection
• SC-8476: SQL Compare now successfully compares comments that are directly after the object name

11.5.8.1398 - May 3rd 2016

Fixes

• SQL Compare XML Report no longer includes an attribute of ‘areidentical’.
• SC-8524: support hardware crypto devices (e.g. nCipher) for asymmetric key encryption
• SC-8482: SQL Compare now correctly adds columns to pre-existing Full Text Indexes when transactions are disabled

11.5.7.1288 - April 25th 2016

• SC-8140: SQL Compare now adds extended properties to sequences in script folders correctly
• SQL Compare XML Report includes a new attribute, ‘areidentical’, to indicate whether the two databases are identical.

11.5.6.1198 - April 18th 2016

Features

• SQL Compare now accepts the ALTER DATABASE CURRENT syntax

Fixes

• SOC-7700: SQL Source Control no longer shows a spurious empty difference after a Get Latest when a table contains certain extended properties
• SC-8302: objects with “ in their name no longer produce an invalid interactive HTML report

11.5.5.1107 - April 12th 2016

Fixes

• SC-8481: Migrations beta now works with TFS server workspaces and other sources containing readonly files.
• SC-8098: SQL Compare now registers STATISTICS_INCREMENTAL=ON from script folders

11.5.4.891 - March 31st 2016

Features

• SQL Compare now connects to SQL Server 2016 RC1.
• New product switcher - accessible from the product logo top-left

11.5.3.659 - March 21st 2016

Fixes

• SC-7985: SQL Compare no longer errors on registration when attempting to decrypt objects on low compatibility level databases
• SQL Compare no longer adds some blank lines or redundant GOs when deploying to a scripts folder
• SQL Compare no longer double-escapes ‘UNKNOWN’ when being unable to read an object name from a CLR assembly.

11.5.2.509 - March 15th 2016

Features

• SQL Compare now connects to SQL Server 2016 RC0.

Fixes

• Trial licences will no longer expire instantly if upgrading from a previous version.
• SC-8341: SQL Compare no longer drops differing indexes while ‘Ignore Indexes’ is selected, unless the index needs to be dropped to implement a requested table change.
• SC-8324: SQL Compare now successfully compares permissions on Sequence objects.
• SC-8138: Asymmetric keys with NA algorithm (e.g. from hardware EKM) no longer cause comparison to fail.
• SQL Compare no longer adds some blank lines or redundant GOs when deploying to a scripts folder

11.5.1.313 - March 8th 2016

Fixes

• SC-8349: SQL Compare can now compare DEFAULT namespaces in selective xml indexes.
• SC-8337: SQL Compare no longer rebuilds views due to full text index changes
• SDC-1816: no longer crashes on startup if your MSI installed locations are corrupted or missing.
• SC-8327: SQL Compare no longer treats DUMP as a reserved keyword.

11.5.0.397 - February 29th 2016

Fixes

• SC-8218: SQL Compare now correctly scripts out computed columns that use the PARSE and TRY_PARSE functions.
• SC-8313: SQL Compare no longer fails to register Azure v12 databases that have been upgraded around 25th February 2016.

11.4.11 - February 15th 2016

Fixes

• SQL Compare can now register repositories from SQL Source Control when the SQL Source Control 5 Beta is installed

11.4.10 - February 8th 2016

Fixes

• SC-8177: SQL Compare no longer fails when comparing against a scripts folder where a table referenced by a foreign key has been deleted.
• SC-8223: SQL Compare can now compare snapshots and script folders that have tables with CREATE TRIGGER statements with preceding semicolons.

11.4.9 - February 3rd 2016

Fixes

• SQL Compare now has a SHA-256 digital signature.
• SC-8198: SQL Compare’s XML reports can now be displayed in web browsers when they contain characters unsupported by XML.
• SC-8206: When a column type is changed from datetimeoffset to datetime2, SQL Compare no longer rebuilds the table or produces an Invalid Cast warning on deployment. This is because the conversion between these types is an implicit cast in SQL Server, so neither of these actions were necessary.

11.4.8 - January 25th 2016

Fixes

• Fixed an error registering views on Azure SQL Database V11.

11.4.7 - January 18th 2016

• SQL Compare now requires .NET 4.0 to be installed.

Fixes

• SC-8115: SQL Compare now sorts foreign keys more consistently
• SC-8186: SQL Compare now allows NULL/NOT NULL in variable declarations in natively-compiled stored procedures.
• SC-8151: SQL Compare no longer enters an infinite loop when parsing a particular bit of invalid SQL syntax.

11.4.6 - January 11th 2016

Fixes

• SC-8156: When comparing a live database of version SQL Server 2014SP1 or later to a scripts folder, incorrect differences are no longer detected between indexes on memory optimized tables.
• SQL Compare no longer recreates statistics due to case changes in column names when the ‘Use case-sensitive object definition’ option is not set.

11.4.5 - December 21st 2015

Features

• SQL Compare now reads tables and indexes more quickly, especially those in schemas with many partitions. Applies to SQL Server 2005 and onwards, as well as Azure V12.

Fixes

• When the Ignore Nullability option is turned on, target field nullability is now correctly preserved when tables are rebuilt in deployment.
• SC-8158: SQL Compare no longer crashes when registering a fulltext stoplist on an invalid server version.
• SC-8160: INCLUDED columns on an Index will now always written out in same order regardless of what order they were created.
• SC-7661: Foreign keys are now rebuilt when changes are deployed to the referenced column even if the IncludeDependencies option has not been set.
• SC-7331: When deploying changes to a table referenced by a foreign key, if the table that the foreign key constraint is on is not selected for deployment, the foreign key will now be rebuilt using the target database’s definition.
• SDC-2007: SQL Compare no longer fills its log file with warnings when trying to connect to some versions of SQL Source Control. internal: Added a new parameter to the Database.Register method that allows how scripts folders are registered to be overridden.

11.4.4 - December 14th 2015

• SC-8100: The “Ignore Migration scripts for Databases” option now also works when using a source control system as a deployment source.
• SC-8081: Added support for reading the ALTER ROLE ADD MEMBER syntax when reading from a scripts folder.
• SQL Compare now recreates extended properties on foreign keys that it drops and recreates as part of a deployment.
• SQL Compare now accepts the CREATE and ALTER syntax for availability groups when reading from a scripts folder or as part of a stored procedure or function definition.
• Added support for deployment of SOC 5 migrations
• Various performance improvements aimed at the SQL Source Control scripts folder cache.

11.4.3 - December 9th 2015

Note: Version 11.4 rolls up all of the changes from frequent update versions 11.3.1 to 11.4.3 - if you want to receive these kinds of updates more quickly in future, you should turn on Frequent Updates.

Fixes

• Fixed an issue where in certain circumstances it wasn’t possible to upgrade to the latest version of SQL Compare.

11.4.2 - December 8th 2015

Fixes

• SC-8114: Added Support for ONLINE and SORT_IN_TEMPDB index options when the database source is a script folder
• SC-8084: Fixed a scenario where Full text indexes were not being deployed when the “Don’t use transactions in deployment scripts” option was selected.

11.4.1 - December 1st 2015

Features

• SC-2413: New ‘Ignore nullability of columns’ project option SQL Compare now gives you the option to ignore column nullability. This means that when you change a column from NULL to NOT NULL (or vice versa), it won’t appear as a difference during comparison, or be deployed as a change. If you need SQL Compare to ignore column nullability, you should turn on the ‘Nullability of columns’ project option (Edit Project… -> Options -> Ignore -> Nullability of columns). To use the option in the command line, add IgnoreNullability or its alias in to your list of options.
• SC-8037: New ‘Use compatibility level’ project option SQL Compare now allows you to select if you would like to use the server’s version or the database’s compatibility level to detect supported features. The default is to ignore the database compatibility level setting, and solely rely on the server version, which is a change in behaviour from previous versions of SQL Compare. If you need SQL Compare to treat databases as if they really are the SQL Server version indicated by their compatibility level setting (for example, if you are using compatibility level to simulate a legacy production environment in development), you should turn on the ‘Use compatibility level’ project option (Edit Project… -> Options -> Behaviour -> Use database compatibility level).
• New SQL Server 2016 and Azure SQL Database features The following new features of SQL Server 2016 CTP 3 and/or Azure SQL Database are now supported by SQL Compare:
  • Stretch database
  • Dynamic data masking
  • Row-level security (including both filter and block predicate support)
  • Columnstore indexes on in-memory tables

Fixes

In version 11.4.1 * SC-8094: FILESTREAM columns are no longer dropped before table rebuilds. This means the deployment no longer throws an error when transferring data to the temporary table during the table rebuild. * SC-8102: When the Ignore Extended Properties option is disabled, extended properties on sequences now appear in comparison and deployment. * SC-8103: SQL Compare no longer incorrectly sets the REMOTE_DATA_ARCHIVE option on Azure tables. An erroneous warning about stretch tables no longer appears when deploying Azure tables. * SC-8110: SQL Compare now supports DDL triggers defined for the CREATE_COLUMN_MASTER_KEY and DROP_COLUMN_MASTER_KEY event types. These event types are new to Azure SQL Database V12 and SQL Server 2016 CTP 2.3. This also means that SQL Compare no longer fails when comparing DDL triggers defined for event groups containing those event types (e.g. DDL_DATABASE_LEVEL_EVENTS). * SC-8113: An erroneous warning about stretch tables no longer appears when deploying a stretch table to a scripts folder. From previous 11.3.x frequent updates * SQL Compare no longer hangs when comparing scripts folders on single-core machines. * Warnings are no longer incorrectly shown when deploying columns with the SPARSE and COLUMN_SET options to an Azure database * SC-4529: Databases with more than 32678 users no longer cause SQL Compare to fail with an ‘Arithmetic overflow error for data type smallint…’ during registration * SC-6455/SC-7904: Trigger definitions with leading semicolon ‘;’ characters no longer cause an error * SC-6900: SQL Compare now correctly reads the POISON_MESSAGE_HANDLING status from queues in SQL Server 2008 R2 databases. * SC-7201: SQL Compare now correctly reads VIEW CHANGE TRACKING permissions from the database * SC-7234: SQL Compare no longer occasionally crashes with a message similar to “Invalid type value supplied. Type: Tablename: type” when comparing databases * SC-7815: Using the SPARSE keyword in table definitions in stored procedures no longer causes parser errors * SC-7822: Comparing a scripts folder containing a stored procedure with ALTER SERVICE ROLE in its body no longer causes an error. * SC-7851: The new objects section of the Interactive HTML report (objects that are being CREATEd) now correctly populates the target object name column, rather than duplicating the owner information column. * SC-7919: SQL Compare can now successfully drop filestream columns, because it no longer tries to drop UNIQUE constraints on the ROWGUIDCOL before dropping the column * SC-7977: Identical XML schema collections with duplicate enumeration values are no longer incorrectly reported as different * SC-7982: Partition values of partition functions using datetime2 and real data types are now correctly deployed * SC-8004: The Add database USE statement option is no longer ignored when comparing two revisions of a source-controlled database * SC-8005: SQL Compare no longer requires VIEW SERVER STATE permissions to register databases on SQL Server 2008 and later * SC-8006: Extended properties defined in a scripts folder in a file called ‘ExtendedProperties.sql’ are no longer ignored * SC-8008: Mapping two schema names that only differ by whitespace no longer causes Compare to fail to map tables * SC-8023: All connection strings used by SQL Compare to connect to SQL Server now include the application name “Red Gate Software - SQL Tools” * SC-8029: SQL Compare will no longer incorrectly try to deploy unsupported INCLUDE columns on indexes to SQL Server 2000 databases (including databases on higher SQL Server versions with COMPATIBILITY LEVEL set to 80). Instead, it will issue a warning that INCLUDE columns are not supported. * SC-8030: Indexes with INCLUDED columns no longer show spurious differences when the source or target databases are in SQL 2000 compatibility level * SC-8033: SQL Compare will use the target database name, rather than using the source database details, to create a new database when comparing to a database that does not exist. * SC-8036: Primary keys defined with unspecified clustering are now correctly registered as NONCLUSTERED when another clustered index exists * SC-8038: Trigger definitions will no longer be lost when deploying a table rebuild to a scripts folder * SC-8048: When the ‘Ignore system named constraint and index names’ option is enabled, constraints and indexes that differ only in their system-namedness are no longer considered different. This also means that when named constraints or indexes are modified and become system-named, SQL Compare no longer drops them without recreating them. * SC-8056: Differences in Users’ database level permissions are now correctly ignored when the Ignore users’ permissions and role memberships option is enabled * SC-8059: User defined DEFAULT constraint names are no longer omitted from the deployment script when the Ignore constraint names option is used. * SC-8062: Square brackets are now correctly ignored in table-valued function definitions containing multiple WITH option clauses when the Ignore square brackets in object names option is turned on. * SC-8065: SQL Compare now ignores any partition functions and partition schemes that have been system-generated by full-text indexing. * SC-8082: SQL Compare will now ignore differences in the names of constraints where one of the source or target constraints is system-named and the Ignore system-named constraint names option is used. * SDC-1952: SQL Compare no longer freezes when you switch to a password field with the touch keyboard enabled in Windows 10.

Known Issues

Dynamic data masking functions configured through the Azure portal will not be detected by SQL Compare. Functions configured through T-SQL on Azure are fully supported.

11.4.0 - November 17th 2015

Fixes

• SC-7851: The new objects section of the Interactive HTML report (objects that are being CREATEd) now correctly populates the target object name column, rather than duplicating the owner information column.FREQUENT UPDATES RELEASE