Deploy changes using source control

You can deploy changes from or to source control using dbForge Studio:

• When you set a source control version as the source, a synchronization script can be executed directly against the target database.
• When you set a source control version as the target, the Studio generates a synchronization script that can be saved to a file.

Note

Source control versions cannot be modified directly.

Deploy changes as the source

1. Open the New Schema Comparison wizard in one of these ways:

• In the top menu, select Comparison > New Schema Comparison.
• On the Start Page, select Database Sync > New Schema Comparison.

2. On the Source and Target page:

• Under Source:

  1. In Type, select Source Control.

  2. In Repository, select the required repository.

  3. In Revision, select the revision from version control.

• Under Target:

  1. In Type, select Database.

  2. In Connection, select a server.

  3. In Database, select a destination database.

Tip

To select a specific revision from the source control history, click Select a specified revision and follow the instructions in Select a version control revision.

3. Optional: On the Options page, configure the comparison settings.

4. On the Schema Mapping page, map schemas.

5. On the Table Mapping page, map tables and columns.

Note

The database objects with the same names are mapped automatically.

6. Click Compare.

The comparison results appear in the Schema Comparison document.

By default, all objects are selected for synchronization. To exclude objects from synchronization, clear the checkboxes for the corresponding objects.

7. At the top of the document, click to open the Schema Synchronization Wizard.

8. Select Execute the script directly against the target database.

9. Click Synchronize.

Deploy changes as the target

1. Open the New Schema Comparison wizard.

2. On the Source and Target page of the wizard:

• Under Source:

  1. In Type, select Database.

  2. In Connection, select a server.

  3. In Database, select a destination database.

• Under Target:

  1. In Type, select Source Control.

  2. In Repository, select the required repository.

  3. In Revision, select the revision from version control.

Tip

To select a specific revision from the source control history, click Select a specified revision and follow the instructions in Select a version control revision.

3. Optional: On the Options page, configure the comparison settings.

4. Click Compare.

The comparison results appear in the Schema Comparison document.

By default, all objects are selected for synchronization. To exclude objects from synchronization, clear the checkboxes for the corresponding objects.

5. At the top of the document, click to open the Schema Synchronization Wizard.

6. Select Save the script to a file and enter the path to the file that will store the script.

7. Optional: Select Open script in the internal editor to view and modify the script in the editor.

The Append timestamp to the file name option is selected by default. To exclude the date and time from the file name, clear the checkbox.

8. Click Synchronize.