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:
   
   • Create a project that compares the snapshot with a database
   • Create a project that compares the snapshot with another snapshot, or with a scripts folder.
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.

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:
   
   • Create a project that compares the scripts folder with a database
   • Create a project that compares the scripts folder with another set of scripts
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.