SQL Compare 10 adds table mapping

Prevent data loss when deploying tables or columns that have been renamed.
January 10, 2012
Feature Release

SQL Compare is a tool for comparing and synchronizing SQL Server database structures. It is used by over 150,000 database administrators, developers and testers. It automates the process of distributing database changes made on a local database, to testing, staging or live databases on remote servers. SQL Compare Pro contains a command-line interface and you can compare and synchronize SQL Server database schemas and automate tasks.

The following editions are available:

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.

About Red Gate Software

Since 1999, Red Gate Software has been developing ingeniously simple tools that simplify the business of working with SQL Server, .NET and Exchange. Its tools, which include SQL Compare, SQL Backup and ANTS Performance Profiler, have become industry standards for developers and DBAs worldwide. It counts Microsoft, HP, Sage, Bank of America, AT&T, The US Treasury, and over 100,000 other leading organizations as customers with over 500,000 Microsoft technology professionals currently using Red Gate products.

 

Synchronizing SQL Server database with SQL Compare.

Redgate SQL Developer Bundle

12 essential tools every database developer needs.

Got a Question?

Live Chat with our Redgate Software licensing specialists now.