SQL Compare 9

About SQL Compare

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:


Didn't find what you were looking for?