About SQL Compare
Published 04 June 2013
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.
Quick start guide
- Choose the data sources to compare
- View the comparison results
- Set up the deployment
- 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)