SQL Compare 10.2.3

New feature: scripts folder static data support

If you’re currently running both SQL Compare and SQL Data Compare to generate a SQL deployment script from a scripts folder, you will no longer need to run both: SQL Compare, with its new command line option /include:StaticData will now include static data (which you will still have to deploy to the script folder with SQL Data Compare or commit with SQL Source Control) in the deployment script that it generates/runs. It even puts the static data changes into the same transaction as the schema changes. 

Known issues: 

Some users who have customized the folder layout of their script folders (i.e. which folders contain which object types) may encounter a NullReferenceException in ScriptDatabaseInformation.ReadFromXml. 

If you encounter this exception, deleting the file found at C:\Documents and Settings\<your username>\Local Settings\Application Data\Red Gate\SQL Compare\WriteToFileOptions.xml should fix the issue – SQL Compare will write out a new WriteToFileOptions.xml in the correct format. 

You may need to re-enter your custom folder layout in the usual place and save your default settings for this feature again to restore your default settings to your usual layout. 

Improvements: 

New command line option /[include:staticdata] 
Migration scripts from other branches can now be used - just deselect them from the deployment wizard if they are not relevant 
Partitioned index warnings now correctly report filegroup names rather than partition scheme names 
Allow Page Locks and Allow Row Locks options now supported on view indexes 
Command line now correctly handles renamed identity columns in script folder tables 

Bug fixes: 

SC-5968: Command line now shows basic help again if no parameters are specified 
SC-5598: Individual objects covered by migration scripts are now listed in action list 
SC-5657: Columnstore indexes no longer cause an exception during comparison 
SC-4824: Parameter defaults with scientific notation and other variant number literals now parse correctly 
SC-5743: Names of user defined types in user defined table type definitions are now fully qualified 
SC-5815: 'Open in SQL Data Compare' button now works correctly for projects with source-controlled databases 
SC-5872: Indexes for temp tables used during rebuild should now correctly prefix names to avoid name collisions 
SC-5670: Constraints on tables not in default schema now work correctly with existence check option 
SC-5959: Now removes WITH APPEND on CREATE TRIGGER statements when targeting SQL Server 2012 
SC-2020: Default constraints should no longer have different bracketing between SQL Server 2000 and later versions 
SC-5898: Typo fix in script creation options 
SC-5320: Advice to use migration scripts in warnings will no longer show up when you are already using migration scripts

SQL Compare 10.2.5

This is a minor release that fixes a few issues found in 10.2.3.1, including the major known issue from the last post regarding custom script folder layouts, but also including:

• 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 behavior (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 

Bug fixes:

SC-6072 - fixed failure to start SQL Compare when custom script folder layout options were specified in previous versions 
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-6085 - fixed a crash on getting latest changes with SOC with the sysname datatype in a table 
SC-5599 - rare CrytographicException 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