Red Gate releases new SQL Data Compare v3 for simple, fast, data movement and comparison

CAMBRIDGE, England, July 29, 2003 – Red Gate Software has released a new version of SQL Data Compare that enables simple and fast data movement and comparison.

SQL Data Compare V3 handles all data types, including text, ntext and pictures. It features a new user interface and significant speed improvements over previous versions.

The re-write of SQL Data Compare is designed for developers and DBAs who frequently move and verify data between SQL Server databases. Examples include updating website prices, providing a sales team with the most up-to-date information, or making sure a back-up server has the correct information on it.

"A typical replication process requires eight or more complex steps," says Simon Galbraith, Red Gate's Marketing Director. "A lot can go wrong and, when it does, it is very difficult to find the source of the problem. Moving data between two databases is a three-step process within SQL Data Compare V3: select the databases, compare and synchronize. The software verifies that data has been moved and makes it easy to see whether your replication has worked as you intended."

For complex situations, such as when there are data conflicts or connectivity has been lost, SQL Data Compare displays the current status and allows users to automatically resolve conflicts and move databases back in synch.

"Does what it sets out to do"

SQL Data Compare's new user interface provides color coding and side-by-side displays of content that give users a quick visual understanding of database differences. The software guides users through the simple processes required to identify differences, generate new scripts, and synchronize databases.

"It's user friendly," says Jim Orzel, supervisor of data operations for International Datashare Corp., a data management company for the petroleum industry. "Everything you need for comparison is right there on one screen. There is no need to move back and forth between menus and different screens."

"It's very intuitive," says Jasper Smith, a SQL Server Most Valued Professional (MVP). "The interface is clean and it's obvious what everything is there for."

The speed of SQL Data Compare V3 also impresses Orzel and Smith.

"I was pleasantly surprised by the speed," says Smith. "I usually hand-code SQL queries when moving databases between environments and doing synchronization and replication checking. With SQL Data Compare, I can save up to several hours for each database."

Orzel says he was able to compare and synchronize databases as large as 1.6 GB in 10 minutes, about twice as fast as he expected.

"SQL Data Compare V3 is simple, quick and it saves time," says Smith. "Simply put, it does what it sets out to do."

A free, fully functional and supported trial version of SQL Data Compare V3 can be downloaded from the Red Gate website. The site also provides a video demonstration of the product in action.

About SQL Data Compare

SQL Data Compare is used by more than 50,000 developers and DBAs worldwide. It is used by half of Fortune 500 companies and by major government agencies worldwide. SQL Data Compare can also be purchased as part of Red Gate's SQL Bundle, which also includes SQL Compare for comparing and synchronizing database structures, and DTS Compare for comparing SQL Servers.

About Red Gate Software

Red Gate Software makes simple tools for Microsoft developers and DBAs. The company is a Microsoft Gold Visual Studio .NET launch partner and a VSIP partner. Other developer tools by Red Gate include ANTS Profiler for understanding and fixing .NET code problems, and ANTS Load for load-testing .NET web applications.

###

Press Contacts: Jill Aitoro, Bob Cramblitt
Cramblitt & Company
tel. 919-481-4599
cramco@cramco.com