SQL Compare - 10.0

SQL Compare

Setting data sources - SQL Compare

When you create a new comparison project, SQL Compare requires information about which two data sources you want to compare, and how to connect to them. You enter this information on the Project Configuration dialog box.

Selecting data sources

Specify the two data sources you want to compare in the Data Sources tab. You specify a source and a target.

The source is the data source that will not change. The target is the data source that will change.

To switch the source and target, click

You can compare the following types of data source:

  • Database

    A database you can connect to on a SQL Server. You will need to enter connection details.

    If you want to compare Oracle or MySQL databases, see: Schema Compare for Oracle / MySQL Compare.

  • Backup

    Native SQL Server backups or Red Gate SQL Backup backups. You can specify a backup as a data source only if you are using SQL Compare Professional edition.

    For more information, see: Working with backups.

  • Snapshot

    A file produced by SQL Compare that contains information about the structure of a database.

    For more information, see: Working with snapshots.

  • Source Control

    There are two options for the Source Control data source:

    • Direct from source control

      A revision of a database from a source control repository.

      For more information on getting your database into source control, see: Getting started - SQL Source Control.

    • Scripts folder

      A folder containing the SQL creation script files that collectively define the database structure. This is usually organized into a number of subfolders.

      For more information, see: Working with scripts folders.

    You can specify Source Control as a data source only if you are using SQL Compare Professional edition.

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

If you select a snapshot or a backup as the target, the snapshot file or backup will not be modified. Instead, a deployment script is generated to modify the database from which the snapshot or backup was made.

If you select a scripts folder as the target, you can choose to modify those script files directly during deployment, or to create a deployment script to modify the database from which the scripts folder was created.

Selecting a database

  1. Under Source or Target, select Database.
  2. Type or select the name of the SQL Server in the Server box.

    If you experience problems selecting a SQL Server that is not running on the LAN, for example if you are accessing the SQL Server via an Internet connection, you may need to create an alias to the SQL Server using TCP/IP (refer to your SQL Server documentation for details). You can then type the alias name in the Server box to connect to the remote SQL Server.

    To refresh the Server list, right-click the box and click Refresh, or scroll to the top of the list and click Refresh.

  3. Select the authentication method, and for SQL Server authentication enter the User name and Password.

    If you want SQL Compare to remember your password, select the Save password check box.

  4. In the Database box, type or select the name of the database.

    If you want to create a new database, at the top of the database list, click Create Database. For full details, see: Creating a new database.

To refresh the Database list, right-click the box and click Refresh, or scroll to the top of the list and click Refresh.

Selecting a backup

  1. Under Source or Target, select Backup.

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

    To specify a network path, type the full path, including the server name, for example:

    \\ServerName\MyFolder\MyFile

    If any of the files you add are encrypted, the Decrypt Backup Files dialog box is displayed. Enter the password to decrypt these files.

To use a differential backup as a data source, you must also add the associated full backup.

Note that SQL Compare does not support using partial, filegroup, or transaction log backups as a data source.

When you have added a backup set, one of the following icons is displayed:

The backup set is valid and complete.

Select the check box to use this backup as a data source.

The backup set you have selected cannot be used as a data source.

This error is shown if the backup is corrupted, or if you have selected a partial, filegroup, or transaction log backup.

One or more files in the backup set is encrypted.

Click the padlock icon to display the Decrypt Backup Files dialog box.

Either the backup set is incomplete, or a differential backup has been added without the corresponding full backup.

Selecting a SQL Compare snapshot

  1. Under Source or Target, select Snapshot.
  2. In the Snapshot box, select the name of the snapshot, or click to browse to the snapshot file.

SQL Compare displays information about the database from which the snapshot was created.

Selecting a revision from source control

  1. Under Source or Target, select Source Control, and then select Direct from source control:

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

Selecting a scripts folder

  1. Under Source or Target, select Source Control, and then select Scripts folder.
  2. In the Scripts Folder box, select the folder, or click to browse to the folder.

See also

Mapping owners

Setting project options

Working with projects

Working with backups

Viewing the comparison results

Working with snapshots

Working with scripts folders

Was this article helpful?

Search support
Forums
Visit the SQL Compare forum.
Learning SQL Compare
Knowledge base

SQL Compare

all SQL products

all products

Notes & articles

SQL Compare

all SQL products

all products

Demos & walkthroughs

SQL Compare