With SQL Compare, you can compare and deploy the structure of two Microsoft SQL Server databases.

This is useful, for example, in a development environment when changes made to a local database need to be transferred to a live database on a remote server. Traditionally, this meant spending hours scrutinizing the database structure and hand-generating migration scripts. SQL Compare automates this process for you.

You can use SQL Compare to compare and syncronize  SQL Server 2008, SQL Server 2005, SQL Server 2000, and SQL Azure databases.

Quick start guide

1. Choose the data sources to compare
2. View the comparison results
3. Set up the synchronization
4. Create the synchronization script

Worked examples

Learn more about SQL Compare by following these detailed examples:

• Comparing and synchronizing two databases
• Using SQL scripts as a data source (requires SQL Compare Professional edition)
• Deploying with migration scripts (requires SQL Source Control)