SQL Compare 13

Comparing databases on unconnected SQL Servers

You can compare databases on unconnected SQL Server instances by creating SQL Compare snapshots or scripts folders from the databases.

Using snapshots

To compare databases on unconnected SQL servers using snapshots:

  1. Create a snapshot of the database(s).

    For more information, see: Working with snapshots.

  2. Copy the snapshot to the required location.
  3. Do one of the following:
  4. Run the comparison on the project.
  5. Select the database objects you want to include in the deployment.
  6. Use the deployment wizard to generate the deployment script.

When a snapshot is the target, the deployment creates a script to update the database from which the snapshot was created. Snapshots cannot be modified directly.

Using scripts folders

To compare databases on unconnected SQL servers using scripts folders:

  1. Create a scripts folder from the database(s).

    For more information, see: Working with scripts folders.

  2. Copy the scripts folder to the required location.
  3. Do one of the following:
  4. Run the comparison on the project.
  5. Select the database objects that you want to include in the deployment.
  6. Use the deployment wizard to update the database schema, object script files or generate a deployment script.
Scripts folders are only available in SQL Compare professional edition.

Didn't find what you were looking for?