SQL Compare Suite

SQL Compare Suite 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 Compare Suite 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. 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 invalid 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 Compare Suite into a fully-featured database version control system. The included command-line utility enables automated and scheduled updates.