Do SQL compare & synchronize your databases with SQL Examiner, keeping your systems up to date.


by Michael Kappel

Article by Dennis Jaylen

This new release performs an analysis on your database structure, identifying changes 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 carries out an analysis on your database structure, identifying changes and exporting them as a hot-fixes that you can apply as updates without affecting your data.

SQL Examiner is currently in its 2009 R3 release, targeting the simplification of database development, maintenance work and application of hot-fixes. Retaining existing data intact, particularly live data if necessary, is a very challenging task when performing changes on the structure of a database. For precisely that, the database version control feature allows 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 tasks can therefore be performed swiftly and optimally, extracting and applying changes to MS SQL Server databases, compatible with versions 7.0 through 2008 and covering all available editions. Added to this, all the object types the various SQL Server versions used are recognized and supported, while processing a variety of possible database forms allows for a greater 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 flexible, allowing for a choice between step-wise processing and using SQL Compare in a command-line form, 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 take place. 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 changes that could make your system dysfunctional. SQL Examiner takes care not to let this happen by carefully analyzing all the modifications to be applied and clearly presenting any possible issues that arise. When such issues arise, the user is provided with a number of choices, including:* mass updates of values with default, valid ones* perform only a partial update, leaving the changes causing the problem back* ignore warnings and perform synchronization in spite of this* cancel the whole process

Visit TulaSoft LLC’s website at http://www.sqlaccessories.com and download the latest version of SQL Examiner available to try out before purchasing 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 problems, and offer or a command-line tool for simpler automatic calls will make your life as a database administrator much simpler.

With prices starting as low as 160€, this SQL compare tool offers minor updates for free, major ones with heavy discount and technical support without charge in addition to the actual software.

About the Author

I know everything about sql compare and synchronization!

Find More Database Development Articles

Technorati Tags: compare, Databases, date., Examiner, Keeping, synchronize, systems

Leave a Reply

*