Improvements to the options API for Comparison SDK. This includes breaking changes which will require you to update your code to support the new SDK version – see Breaking changes in SQL Comparison SDK 10.5 for further details.
Fixes
SC-6830: SQL Compare no longer raises an error when the THROW syntax does not have an argument
SC-6032: Ignore system named contraints now correctly ignores default system named constraints
SC-5850: SQL Compare no longer causes a Utils.EncloseInSquareBrackets.NullReferenceException error
SC-6885: SQL Compare no longer throws a InvalidCastException when attempting to register a scripts folder containing filetables
SC-6770: Fixed an issue where the Deployment wizard could skip the ‘Reviewing dependencies’ step
SC-6664: SQL Compare no longer causes an error on the POISON_MESSAGE_HANDLING keyword in queues
SC-6613: SQL Compare no longer causes an error on the ‘MERGE’ keyword when target is table object
SC-6942: SQL Compare no longer demands .NET 3.5 on Windows 8 machines
SC-2907: Fixed an issue where SQL Compare might not update a column's data type if the column is a foreign key
SC-6860: The SQL Source Control history dialog no longer displays rogue string – this fix requires a future version of SQL Source Control (v3.5.7.450 and above)
SC-6669: Fixed an issue which was blocking registration of a database when the user has limited rights
SC-6147: Clustered index changes are now handled correctly when working with a SQL Azure database as a target.
SC-2656: Users created from windows logins are now scripted properly
SC-6564: Script no longer GRANTS permissions to the wrong columns after a column is dropped
SC-6894: Syntax highlighting has been updated for ROWS, FIRST and ONLY keywords
When selecting a source control system as the data source the revision number is no longer changed to ‘Head’ when a different source control repository is selected
SC-6317, SC-6402 - Drop and Create instead of Alter option now works correctly with SOC data sources
SC-6381 - NullReferenceException caused by rare dependency situations fixed
SC-5365 - NullReferenceException caused by some queue differences fixed
SC-6575, SC-6291 - Ignoring system-named constraints no longer causes us to drop system-named FKs on table rebuild
SC-2907 - Foreign key migrations where only the target table is selected no longer fail when target data type has changed
SC-6439 - temporary inline indexes during table rebuilds now no longer have a name collision with the final inline index
SC-6493 - trigger dependency on new column of existing table now respected
SC-5951 - LOCK_ESCALATION setting now compared and deployed
SC-5615 - some causes of this exception involving duplication of triggers in script folders have been fixed
SC-6781 - overflow on reading extremely large identity values from script folders fixed
SC-6468, SC-6471, SC-6475, SC-6316, SC-5607, SC-6394, SC-6401, SC-5379, SC-5718, SC-5812, SC-5849, SC-5914, SC-5916, SC-6137, SC-6153, SC-5527 - progress dialog made more robust against a range of conditions
SC-6301, SC-6764, SC-6234, SC-5342, SC-5974, SC-5770, SC-5977, SC-5966, SC-6230, SC-6093 - documentation inconsistencies and omissions fixed, particularly around worked examples and filter syntax
SC-4640 - handling of route lifetimes improved
SC-6566 - TFS connection issue when using migration scripts fixed
SC-6562 - A situation where encrypted objects weren't decrypted is now fixed
SC-6055 - datetimeoffset(0) now consistently displayed when read from script folders
SOC-3873 - money type no longer overflows on very large numbers when reading from script folders
SC-6056 - fixed occasional exception in picking which migration scripts to enable by default
SC-6073 - script folder deployment issue when changing from inline to explicit check constraint fixed
SC-6072 - fixed failure to load projects with custom script folder layout options
SC-6085 - fixed a crash on getting latest changes with SOC with the sysname datatype in a table
SC-5599 - rare Cryptographic Exception when loading some v8 or earlier projects fixed
SC-6099 / SC-5184 - fixed a problem with user deployment with mapped schemas
SC-6019 - fixed a crash in the deployment wizard when script generation fails
SC-5215 - fixed a crash where case sensitivity got unset in the middle of a snapshot comparison
SC-6066 - /include:Identical command line option now no longer incorrectly applies filter rules
SC-6112 - warning to replace deprecated XML file from SOC now displays file name correctly
SC-5677 - /assertidentical and /report command line options can now be used together
Recently used repositories now show their migrations folder (if they have one, in a tooltip (to make it clear what the difference is between repositories with the same main path but different migration folders)
Priority of object selections from filters vs individual selections when using project on the command line should now be identical to UI behaviour (previously some filters took priority incorrectly)
Foreign key dependencies on reference primary keys now enforced for script folders
Including static data in a SQL Compare deployment script no longer also includes the SQL Data Compare comment header
Known issues
Other new features in SQL Server 2014 (including In-Memory Tables) are not currently supported.
SC-6986: A "Data Compression enum value not recognised" error can occur when viewing a table with a clustered columnstore index
SQL Compare 10.5 and 10.6 were internal and beta builds that were not publicly released.