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 deployment scripts. SQL Compare automates this process for you.

You can use SQL Compare to compare and deploy SQL Server 2012, SQL Server 2008, SQL Server 2005, and SQL Azure databases.

Quick start guide

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

Worked examples

Learn more about SQL Compare by following these detailed examples:

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