SQL Compare from Red Gate Software Limited is the industry standard solution for comparing schema from different copies of a database. Comparing database schemes is an essential task to perform before database changes are deployed from a test to a live environment. If an application attempts to run SQL scripts against a database with an outdated schema then this can lead to all kinds of problems, many of which can be difficult to track down.
SQL Compare can automatically create schema change scripts in order to script the changes found between two copies of a database. This makes it straightforward to enact database structural changes in a change control system. Comprehensive reporting options also allow developers and DBA's to check that the database structure hasn't been changed between test and live systems.
SQL Compare can compare live databases, as well as databases that only exist as SQL Server backups, or as schema backups.