• English
• German
• French
• Spanish
• Russian
• Romanian

English

SQL Database Comparison and Synchronization like a Charm!

In addition to detached database files and snapshots, new SQL Examiner Suite (1.2) allows the use of a database backup as a source database for schema and data comparison

TulaSoft, a Microsoft Gold Certified Partner and a premier developer of SQL database comparison and synchronization tools, has announced the immediate availability of SQL Examiner Suite 1.2. This is a suite of tools (SQL Examiner 1.6, SQL Data Examiner 1.2) that provides developers and database administrators with an all-in-one solution for comparison and synchronization of the schema and data of two Microsoft SQL Server databases. Version 1.2 of the suite delivers a new unique feature, allowing backups to be used as a source database when two databases are compared. This considerably simplifies the work of database developers.

SQL Examiner software has been evolving since 2003 and has seen many technological improvements that made it stand out of the other competing products. The engineers at TulaSoft were the first to add support for Microsoft Windows Vista, integrate an opportunity for partial synchronization, and realize support for SQL Server 2005. The company doesn't stop at these achievements, extending the product's functionality with a new unique capability to use backups as a synchronization source and an opportunity to compare them with live databases, which so far has had no analogues among the similar software.

Users of the new version will benefit from the opportunity to spend less time on synchronizing the structure of databases and migration of data. Database administrators regularly create backups of their databases, and no one keeps several versions of one and the same database on the server. To compare the data stored in the backup with that of the working database, users would restore it, which was a severely time-consuming task if the database was large. Unlike similar software, SQL Examiner Suite compares a live database with a backup itself, making the process of comparison much quicker. In doing it, there'll be no need to restore the backup, and it'll be enough to specify the needed database and click 'Compare'.

"We often received requests from our end-users, asking us to add support for a backed-up database so that it can be used as a source of data," says Mikhail Gerasimov, CEO of TulaSoft. "When we added this capability and beta testing began, we got a lot of enthusiastic feedback from the end-users of the beta version. Now, the comparison of a backed-up database and a live one has become handier and quicker, resembling a point-and-click procedure."

Here are some key benefits that the new feature provides:
- Quicker comparison of a backed-up database with a working one. No need to restore a backup as a separate database.
- Quicker and simpler finding of the necessary data, because there is no need to spend time on restoring several old copies.
- Less time is spent on search of changes that were made after creation of the last backup.
- Simple viewing of changes that were made during the period between two backups.
- An opportunity to rollback changes in the data for several tables, while the data in other tables remains unchanged.

SQL developers make plenty of changes to a development database before they migrate its data to a production database, which involves hours of intensive scripting done manually. Errors and their debugging make things even more difficult. SQL Examiner Suite will help developers synchronize schemas and data between two databases in a pain-free manner. Microsoft SQL Server 7.0, 2000, 2005 is fully supported. There is a wide range of opportunities to configure the parameters of synchronization, which allows users to get a synchronization script that fully matches their needs. The end result can be achieved in a few clicks but if necessary, the user can set up practically any parameter of synchronization. The suite is delivered in a friendly interface that is designed in the style of Office 2003 and Visual Studio 2005. The program is Vista-ready and supports all new functions of the newly released OS.

Please, explore the SQL Examiner's website at www.sqlaccessories.com/ to find out more details about the suite. Some areas of note include a 'walk through' step-by-step guide showing how to use SQL Data Examiner, plus a free evaluation copy of SQL Examiner's software.

Pricing and Availability

SQL Examiner Suite 1.2 (includes SQL Examiner 1.6 and SQL Data Examiner 1.2) is compatible with Windows NT 4.0, 2000, XP, 2003, Vista and requires Microsoft .NET Framework. SQL Examiner starts at $199,95 (US), SQL Data Examiner starts at $199,95 (US) and the suite of both products is offered at $299.95, allowing users to save $100 off the original retail price. For more details on the prices, please refer to www.sqlaccessories.com/Order/.

Registered customers are entitled to premium technical support, quick release of fixes, and an opportunity to get a new functionality on demand.

Additional information on the products, as well as their evaluation copies are available from www.sqlaccessories.com.

About TulaSoft

TulaSoft specializes in database comparison and synchronization software for Microsoft SQL Server since 2003. The company's premier product is SQL Examiner and SQL Data Examiner, which are offered as a suite with a considerable price discount. TulaSoft's products have thousands of users in over 30 countries worldwide. The success of the company builds on the ongoing product development in constant collaboration with the real end-users who drive the development of the products. TulaSoft has been awarded a prestigious status of a Microsoft Gold Certified Partner, which acknowledges their success in creation of developer tools under Microsoft platforms. For more information, please visit www.sqlaccessories.com.