Tula, Russian Federation (PressExposure) July 15, 2009 -- For Immediate Release
For more information contact:
TulaSoft, LLC. firstname.lastname@example.org http://www.sqlaccessories.com/>
TulaSoft, LLC announces the release of SQL Examiner, a tool enabling easy synchronization of database structures for database developers using Microsoft SQL Server. The new SQL comparison tool enables easy, automated synchronization between development and production database structures without losing existing data. Database validation functions ensure the resulting database remains valid even if certain structural changes are not compatible with existing data.
About SQL Examiner
Thanks to the new, advanced SQL compare engine, SQL Examiner makes database development, maintenance, and hot-fixing easy and straightforward. Its implementation of database version control enables MS SQL Server developers to compare and synchronize database structures between development and production servers without affecting existing data. The advanced SQL compare engine 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 advanced SQL compare engine can compare SQL databases with data backups, SQL scripts, live databases and database snapshots, making it possible to transfer database structure changes between wide varieties of applications.
The smart SQL compare engine of SQL Examiner attempts to preserve all existing data in the production database. However, certain changes to the structure of a database can make data preservation impossible. For example, an updated database structure can eliminate certain types of records, prohibit NULL values, or implement other changes that would render an updated database invalid. The SQL compare engine analyzes structural changes being applied to existing databases, warning if any conflicts between the new structure and existing data are found. The user can choose among several options, such as filling invalid entries with default values, ignoring the conflict or canceling synchronization altogether. The available partial synchronization mode allows the user to only apply certain changes while ignoring the rest of the differences.
The SQL compare engine of SQL Examiner is fully able to perform complex synchronization tasks, such as synchronizing dependent objects. The advanced SQL compare engine turns SQL Examiner into a fully-featured database version control system. The available command-line tool enables automated and scheduled updates to database structures.