Working with source control

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.

Adding a new SQL source control version

1. Under Source or Target select Source Control.

2. In the Repository box, click < Manage >.

Create source control

3. In the Repository Manager window that appears, click the New button to add a new repository.

Repository manager

4. In the Source Control Repository Properties window, select a type of source control system and follow the instructions.

Source control properties

5. Click OK.

Alternatively, click + or … next to the Repository box.

Selecting an SQL source control version

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.

Select version

Working with source control issues

  • 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.