Ongoing maintenance of a database being used in a production system is very common. Developers have to invent various means of synchronizing database structures between development and production systems in order to apply any modifications. Changes to database structure are often unavoidable in order to facilitate new features or fix bugs. Unfortunately, the beaten path of producing database synchronization scripts for every update of a structure is sub-optimal when it comes to data integrity, safety and effectiveness of the update process.
SQL Examiner ( http://www.sqlaccessories.com/ ) enables simple synchronization of database structures between development and production systems running under Microsoft SQL Server engine. SQL Examiner simplifies database development, maintenance, and hot-fixing. Its database version control makes it possible to MS SQL Server developers to compare and synchronize database structures between development and production systems without affecting existing data. The new SQL compare tool analyzes changes in the database structure, creates a hot-fix, and applies the changes on the production server while preserving data stored in the database.
Compatible with Microsoft SQL Server 7.0, 2000, 2005, and 2008, SQL Examiner supports all types of objects supported by SQL Server. The new SQL compare engine can compare SQL databases with data dumps, SQL scripts, live databases and snapshots, making it possible to transfer database structure changes between a variety of applications.
The smart SQL compare engine makes efforts to preserve all existing data in the production database. However, some modifications to the database structure can make data preservation hard to achieve. For example, an updated database structure can remove certain types of records, prohibit NULL values, or implement other changes that would make an updated database invalid. The SQL compare engine analyzes structural modifications being applied to existing database, alerting if any conflicts between the new structure and existing data are found. The user can choose among several options, such as filling entries with default values, ignoring the conflict or canceling synchronization. Optional partial synchronization mode allows the user to only apply some changes while ignoring the rest.
The SQL compare engine is capable of performing complex synchronization tasks, such as synchronizing dependent objects. The new SQL compare engine turns SQL Examiner into a fully-featured database version control system. The supplied command-line utility enables automated and scheduled updates. The free trial version of SQL Examiner is available for download at: http://www.sqlaccessories.com/
![[Valid RSS feed]](http://www.articlesinsight.com/images/icon_Rss.png "XML Feed For RSS"){kind=icon}
Category Rss Feed
Print This Article
Add To Favorites
