Release notes - version 10.xx

Version 10.0 - December 15, 2011

New features

Rerunnable scripts - options to add existence checks and DROP/CREATE
Recently used servers SQL Compare now remembers the last five connections
Different tables and columns can be mapped, which means renames will no longer be regarded as DROP/CREATE
Transaction Isolation Level can be specified as an application option
New create database functionality from the Project Configuration dialog box, so you can quickly create test databases in SQL Compare
Filters applied to SQL Source Control databases are now picked up by SQL Compare, and applied in the comparison
You can now connect to SQL Server 2012 (Denali) servers
New command line switches

For full details, see: What's new in SQL Compare 10?

Fixes

SC-5244 (OPTION OPTIMIZE not recognized by the parser)
SC-3996 (Disabled triggers now detected)
SC-5056 (Database level extended properties behave strangely)
SC-4930 (Compare always tries to enable change tracking even if already enabled (thus the script fails))
SC-4938 (/Exclude:Additional ignored when syncing from the scripts folder)
SC-4958 (Command line include/exclude options not working)
SC-5089 (Foreign keys not scripted when /scriptfile is used from command line (db -> empty script folder)
SC-4552 (Support: CL behaves differently to UI: with /argfile switch)
SC-5014 (Table level compression not handled well when script isn't ours and when it is, there is an 'invisible difference')
SC-5113 (Comparison reporting identical where SQL differences view highlight a difference (DATA_COMPRESSION = PAGE)
SC-4772 (SQL Compare not listing dependencies on Stored Procedure)
SC-5141 (Create snapshot function unavailable if starting Compare from SSIP)
SC-4937 (Script error changing partition ranges)
SC-4031 (Snapshot creation date on command line)
SC-4974 (Commandline doesn't expose script folder creation options)
SC-5292 (Make it easier to debug the commandline)
SC-5310 (XML INDEX and PRIMARY XML INDEX on same column cause drop/recreate)
SC-5243 (/Makescripts fail on case sensitive servers)
SC-4706 (File format issue with Generate Comparison Results Report)
SC-4980 (Partition function can be incorrectly read by script reader)
SC-4633 (Identically-named partition index works in live database but not script reader)
SC-5309 (Not creating a function in a sync script)
SC-5328 (Change tracking re-enabled in alter statement unnecessarily)
SC-4487 (Circular dependency issue: Table and Table function)
SC-5242 (Next button does nothing during sync)
SC-4674 (Warning for any dropped column)