SQL Data Compare V8.0 released

New version supports multiple transactions in the synchronization script, and project sharing with SQL Compare.

Zoom [+]

Displaying the differences between various databases.

SQL Data Compare is used by thousands of Database Administrators (DBAs), developers and testers worldwide. SQL Data Compare is used when the data between two databases has got out of synch, and saves huge amounts of tedious work in synchronizing them. Others use it as a tool for QA, documentation and verification. With SQL Data Compare you can compare the contents of two databases, automatically synchronize your data. With SQL Data Compare Pro you can compare database backup files as if they were live databases and do row-level data restores. SQL Data Compare fully supports SQL Server 2008.

The following editions are available:

• SQL Data Compare Pro
• SQL Data Compare

SQL Data Compare is also available as part of the following bundle offerings from Red Gate Software:

• SQL Developer Bundle
• SQL Toolbelt
• SQL Comparison Bundle

Updates in 8.0

• The ability to store static data in scripts folders
  SQL Data Compare 8 allows you to store data scripts in a scripts folder, making it easier to keep databases under source control.
• The ability to share projects with SQL Compare
  To open a SQL Data Compare project in SQL Compare, on the Projects dialog box, select a project, right click, and click Launch in SQL Compare.
  Alternatively, to open the current project in SQL Compare, click the SQL Compare icon on the toolbar of the main window.
  You can open a SQL Compare 8.1 (or later) project in SQL Data Compare 8.0 or later.
  You can open a SQL Data Compare 8.0 (or later) project in SQL Compare 8.1 or later.
• Multiple transactions in the synchronization script
  In previous versions, the synchronization can be enclosed in a single transaction. This allows rollback, but can result in poor performance for large databases. In SQL Data Compare 8.0 you have the option to use multiple transactions. You can specify the amount of data included in each transaction using the Application Options.
• User interface refinements
  SQL Data Compare 8.0 includes many of the user interface improvements made for SQL Compare 8, bringing the workflow of the two products closer together.
• Command line changes
  The command line interface now supports column-level inclusion and exclusion. There are changes to the behaviour of some existing switches and options.
• Stability and performance improvements
  SQL Data Compare 8.0 addresses some known stability issues. There are now fewer Out of memory errors when comparing large databases.

For more information visit:
http://www.red-gate.com/about/news/sql_data_compare_8.htm

About Red Gate Software

Red Gate Software counts Microsoft, HP, Sage, Bank of America, AT&T, the US Treasury and over 9,000 other leading organizations as customers of its software development tools. There are over 100,000 Microsoft technology DBAs, developers and testers currently using Red Gate products. The company believes that by producing simple tools that solve the technical problems of Microsoft technology professionals it will continue to add value to the software development community. Therefore, it does not sell 'integrated' software with large, often unnecessary, feature sets. Red Gate was founded in 1999 and moved to Cambridge at the start of the year 2000. It is a privately owned and managed company. Its focus is on Microsoft technologies. Red Gate was chosen as a Global Gold Launch Partner for Microsoft Visual Studio .NET and are a Visual Studio Integration Program partner.