SQL Compare 9

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 synchronization.
  6. Use the synchronization wizard to generate the synchronization script.

Note that when a snapshot is the target, the synchronization 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 synchronization.
  6. Use the synchronization wizard to update the database schema, object script files or generate a synchronization script.

Note that scripts folders are only available in SQL Compare professional edition.


Didn't find what you were looking for?