Software

Do SQL compare & synchronize your databases with SQL Examiner, easily updating production systems.

  • By
  • November 4, 2009

This new edition performs an analysis on your database structure, identifying modifications and exporting them as a hot-fix you can apply as an update without modifying your data.

Compare and synchronize your databases with SQL Examiner, easily updating your production systems from the databases in your development situation. This new release performs an analysis on your database structure, identifying changes and exporting them as a hot-fixes that you can apply as updates without altering your data.

SQL Examiner is presently in its 2009 R3 release, targeting the simplification of database development, maintenance jobs and application of hot-fixes. Keeping existing data intact, especially live data if required, is a very complicated task when making changes on the structure of a database. For exactly that, the database version control feature lets developers using Microsoft SQL Server to perform compare and synchronization tasks between the structures of the development and production system databases, in a method that doesn’t harm your precious data.

These jobs can therefore be carried out quickly and effectively, extracting and applying changes to MS SQL Server databases, compatible with releases 7.0 through 2008 and covering all available versions. In addition, all the object types the various SQL Server versions used are recognized and accomodated, while processing a variety of possible database forms allows for a larger range of options, this including working with data pumps, live or snapshots of databases, as well as SQL scripts.

Managing to perform the needed steps in an automated and controlled fashion, it lowers the occurrence of costly issues to a minimum, as well as release human resources for other work. How is that done? For one, SQL Examiner 2009 R3 is highly versatile, allowing for a choice between step-wise processing and using SQL Compare in a command-line mode, able to configure auto-synchronizations of the databases you own.

During the application of a hot-fix, the engine is intelligent enough to approach the work in a data-preserving way, taking measures not to allow any unauthorized changes to be carried out. Quite frequently, manually updating the structure of an MS SQL Database could result in loss of records, application of NULL-value restrictions and a series of other modifications that could make your system stop working. SQL Examiner takes care not to let this occur by carefully analyzing all the alterations to be applied and clearly presenting any possible issues that take place. When such issues occur, the user is provided with a number of choices, such as:
* mass updates of values with default, valid ones
* perform only a partial update, leaving the problematic changes back
* ignore warnings and perform synchronization anyway
* cancel the entire process

Visit TulaSoft LLC’s website at http://www.sqlaccessories.com and get the latest version of SQL Examiner available to try out before buying any of the available releases differentiating on number of users and functionality available. The software’s advanced features, such as being able to synchronize dependent objects without issues, and offer or a command-line tool for easier automatic calls will make your life as a database administrator much easier.

With prices starting as low as 160€, this SQL compare tool offers lesser updates at no cost, major ones with generous discount and technical support without charge in addition to the actual program.

No Comments Found

Leave a Reply