April 23rd, 2014

New features

• Supports connecting to SQL Server 2014 databases
• 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