SQL Compare Pro and SQL Compare Standard are no longer available. Instead Redgate offer a single offering; SQL Compare now available as a subscription license.
SQL Compare 10 adds table mapping
Released: Jan 10, 2012
Updates in this release
Updates in 10.0
Table mapping - Map together tables and columns with different names; this can be useful to prevent data loss when deploying tables or columns that have been renamed.
Creating a new database to compare - Useful if you want to create a copy of the source database.
Comparing revisions from SQL Source Control - Select specific versions of a source-controlled database to compare.
New command line switches - AbortOnWarnings, IgnoreSourceCaseSensitivity, LogLevel, ShowWarnings, Version1 and Version2.
New project options - Add object existence checks, use DROP and CREATE instead of ALTER, Ignore migration scripts for databases.
Connect to SQL Server 2012 (Denali) servers.
Transaction Isolation Level application option - Set the transaction isolation level used in deployment scripts. You can use this option to prevent deployment errors when using linked servers.