SQL Compare Suite makes database development, maintenance, and hot-fixing easy and straightforward. Its implementation of database version control system enables MS SQL Server developers to synchronize database structures between development and production servers while preserving 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 without affecting data already in the database. Working with Microsoft SQL Server 7.0, 2000, 2005, and 2008, SQL Compare Suite supports all types of objects included with SQL Server. The advanced SQL compare engine can synchronize SQL databases with data backups, SQL scripts, production databases and database snapshots, making it possible to transfer changes in database structure between wide varieties of applications. The new SQL compare engine of SQL Compare Suite attempts to keep all existing data in the production database. A revised database structure can eliminate certain types of records, outlaw NULL values, or implement other changes that would render an updated database invalid. The SQL compare engine analyzes structural changes being applied, warning if any conflicts between the updated structure and existing data are found. The user can choose among several options, such as filling entries with defaults, ignoring the conflict or canceling synchronization altogether. The available partial synchronization mode can only apply certain changes while ignoring the rest of the differences. The SQL compare engine is fully able to perform complex synchronization jpbs, such as synchronizing dependent objects. The advanced SQL compare engine turns SQL Compare Suite into a comprehensive database version control system. The supplied command-line tool enables automated and scheduled updates.
