Comparing databases on unconnected SQL Servers

If you need to compare databases on unconnected SQL Server instances, you can do it by creating either a snapshot or scripts folder from the required databases.

Comparing databases on unconnected SQL Servers using snapshots

To compare databases on unconnected SQL servers using snapshots:

1. With Schema Compare, create a snapshot of a database\databases you want to compare.

For more information, see: Working with snapshots.

2. In the New Schema Comparison Wizard:

  • create a project that compares the snapshot with a database.

-OR-

  • create a project that compares the snapshot with another snapshot, or with a scripts folder.

3. Configure and then run the comparison on the project.

4. Set synchronization options and run synchronization.

Note:

  • When a snapshot is selected as a target, you can select to overwrite it after synchronization.

  • When a snapshot is selected as a source, and a database as a target, the synchronization script can be executed directly against the target database.

Comparing databases on unconnected SQL Servers using scripts folders

To compare databases on unconnected SQL servers using scripts folders:

1. With Schema Compare, create a scripts folder from a database\databases you want to compare.

For more information, see: Working with scripts folders.

2. In the New Schema Comparison Wizard:

  • create a project that compares the scripts folder with a database.

-OR-

  • create a project that compares the scripts folder with another scripts folder.

3. Configure and then run the comparison on the project.

4. Set synchronization options and run synchronization.

Note:

  • When comparing and synchronizing scripts folders either as a target or a source, a synchronization script is created. It can be saved to a file or opened in an internal browser.
  • When a scripts folder is selected as a source, you can select to execute the synchronization script directly target database.
  • When a scripts folder is selected as a target, you can select to update the scripts folder after synchronization.