Setting data sources

Schema Compare for SQL Server gives you a perfect opportunity to compare and synchronize schemas with many useful features. To start a new comparison project, you need to specify two data sources you want to compare, and how to connect to them.

To select Source and Target connections and specify the names of databases to be compared:

1. On the File menu, click New Schema Comparison.

2. In the New Schema Comparison wizard that opens, specify the type of the Source and Target, connection and the names of the databases to be compared.

Setting sources

Selecting data sources

Select the two data sources you want to compare in the Source and Target tab of the New Schema Comparison wizard. You need to specify a source and a target.

Note:

The Source is the data source that will not change. The Target is the data source that will change.

To swap Source and Target settings click Swapping sources

The following types of data source can be compared:

  • Database
  • Backup
  • Scripts Folder
  • Source Control
  • Snapshot

You can select a data source from a Type drop-down list.

Selecting a source type

Note:

You can compare any combination of data source types in your project.

Selecting a database

1. In the drop-down list under Source or Target, select Database.

2. Select the name of the SQL Server in the Connection box.

Note:

If you need to use a new connection:

  1. Click < Manage… > in the drop-down list under Connection.
  2. Then in the Connection Manager window, click New.

New connection

3. Finally, in the Database Connection Properties window specify the details of the connection you want to add.

Database Connection Properties

Alternatively, click the New button.

New button

3. Select a database to be compared from a drop-down list under Database.

To refresh the Database list, click < Refresh… > option at the top of the list.

Selecting a backup

1. In the drop-down list under Source or Target, select Backup.

2. Click Add button to select all the files making up the backup set you want to compare.

Add button

Note:

When you have added backup files, one of the following icons will be displayed:

Tick button The backup set is valid and complete.

Cross button The backup set cannot be used as a data source.

Selecting a snapshot

1. In the drop-down list under Source or Target, select Snapshot.

2. In the Snapshot box, select the name of the snapshot, or click < Browse… > to browse to the snapshot file.

Alternatively, click the Browse button under the drop-down menu.

Browse button

Note: If you need to create a snapshot:

  1. Click the New button (see the screenshot above).
  2. Specify the details in the Create Sripts Folder or Snapshot window that appears. Create snapshot

Selecting a scripts folder

1. In the drop-down list under Source or Target, select Scripts Folder.

2. In the Database scripts folder box, select the name of the scripts folder, or click < Browse… > to browse to the required folder.

Alternatively, click the Browse button under the drop-down menu.

Browse button

Note:

You can create a new scripts folder.

To do this, press the New button and specify the details.

Selecting a Source Control version

1. In the drop-down list under Source or Target, select Source Control.

2. In the Repository box, select a database linked to SQL Source Control, or click < Manage… > to specify or add a repository.

3. In the Revision box, select a specific version from the source control history, or select the latest version.

Revision box