Do SQL Compare & Synchronize Your Databases with SQL Examiner, Easily Updating Production Systems.

By: Dennis Jaylen Click author's name for more of his/her articles

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

Compare and synchronize your databases with SQL Examiner, easily updating your production systems from the databases in your development environment. This new edition 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 work and application of hot-fixes. Keeping existing data intact, especially live data if necessary, is a very challenging task when performing changes on the structure of a database. For exactly that, the database version control feature lets developers utilizing Microsoft SQL Server to perform compare and synchronization tasks between the structures of the development and production system databases, in a manner that doesn't endanger your valuable data.

These jobs can therefore be carried out quickly and optimally, extracting and applying changes to MS SQL Server databases, compatible with versions 7.0 through 2008 and covering all available versions. Added to this, 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 necessary steps in an automated and controlled fashion, it minimizes the occurrence of costly faults to a minimum, as well as release human resources for other tasks. How is that achieved? 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 smart enough to approach the task in a data-preserving manner, taking measures not to allow any unauthorized changes to be carried out. Quite commonly, manually updating the structure of an MS SQL Database could result in disappearance 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 modifications to be applied and clearly presenting any possible issues that take place. When such issues arise, 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 in spite of this
* cancel the entire process

Visit TulaSoft LLC's website at http://www.sqlaccessories.com and download the latest version of SQL Examiner available to try out before buying any of the available versions differentiating on number of users and functionality available. The program'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 minor updates at no cost, major ones with heavy discount and technical support without charge in addition to the actual software.