Schema Compare allows you to select an SQL source control version either as a target or as a source as well as to create a new SQL source control version.
1. Under Source or Target select Source Control.
2. In the Repository box, click < Manage >.
3. In the Repository Manager window that appears, click the New button to add a new repository.
4. In the Source Control Repository Properties window, select a type of source control system and follow the instructions.
5. Click OK.
Alternatively, click + or … next to the Repository box.
1. Under Source or Target select Source Control.
2. In the drop-down list of the Repository box, select a repository.
3. In the Version box, select a specific version from the source control history, or select the latest version.
When source control version is a target, Schema Compare creates a synchronization script that can be saved to a file. Source control versions can not be modified directly.
When a source control version is a source, a synchronization script can be executed directly against the target database.
Schema Compare doesn’t allow Working Folders comparison. Try using Scripts Folders instead.