SQL Compare 8

Getting started with the add-in

With SQL Compare, you can compare and synchronize databases, including versions from source control, from within SQL Server Management Studio.

Comparing databases

To compare two databases from SQL Server Management Studio:

  1. In the SQL Server Management Studio Object Explorer, right-click a database you want to compare, and click Compare schema to:

    The Schema and Data Compare tab is displayed, with the database you selected set as the source in the leftmost pane:

  2. In the rightmost pane, select the database you want to set as the target:

    To switch the source and target and databases, click .
    For more information on selecting databases to compare in SQL Compare, see: Setting data sources.

  3. Click Compare schema now.
    SQL Compare launches, displaying the comparison results.

Comparing a version from source control

The SQL Server Management Studio add-in enables you to compare and synchronize versions of a database linked to SQL Source Control 1.1 or later.

To set a version from source control as a data source:

  1. In SQL Server Management Studio Object Explorer, right-click a database you want to compare, and click Compare schema to:

    The Schema and Data Compare tab is displayed, with the database you selected set as the source in the leftmost pane:

  2. In the upper pane, under Compare To, select Source Control:

  3. In the Repository box, select a database linked to SQL Source Control, or click <Browse source control...> to specify a repository URL.
  4. In the Version box, select a specific revision from the source control history, or select the latest revision:

  5. Click Compare Now.
    SQL Compare launches, displaying the comparison results.

Didn't find what you were looking for?