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.
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:
-OR-
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.
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:
-OR-
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.