SQL Compare 10.0 has been released
http://www.red-gate.com/products/sql-de ... l-compare/
If you have any feedback about v10, please let us know on our uservoice forum at: http://redgate.uservoice.com/forums/141 ... uggestions
What's new in v10?
â€¢ Migrations (custom change scripts): you can now create, store and share migration scripts for accurate, automated deployment using SQL Source Control and SQL Compare.
See here for more information:
www.red-gate.com/supportcenter/Content/ ... Migrations
Other new features:
â€¢ Rerunnable scripts - options to add existence checks and DROP/CREATE.
â€¢ Recently used servers â€“ We remember the last 5 connections now.
â€¢ 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 Config dialog so you can quickly create test databases from within SQL Compare
â€¢ Filters applied to SQL Source Control databases are now picked up by SQL Compare and applied in the comparison.
â€¢ Connection to Denali servers allowed
â€¢ Maximize button added to deployment wizard
â€¢ New commandline switches including:
o logging on the commandline
o show warnings that apply to the deployment
o use databases linked to SQL Source Control for comparison/deployment
o Ignore case sensitivity option when creating scripts folders
For more information on the new features, see:
http://www.red-gate.com/supportcenter/C ... ts_new_v10
â€¢ 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)