Source Control operations overview

Source control operations refer to key actions and processes involved in version-controlling and managing changes to database objects using a source control system, such as Git, Subversion, or others.

After you link a database or static data to a remote repository or a working folder using dbForge Studio, you can make changes to database objects and then manage them in the Source Control Manager.

Commit changes to version control

The Commit operation sends local changes to the remote repository, making them available to other developers.

In the Local changes section:

1. Select the objects you want to commit.

2. Optional: Enter a comment in the commit message field.

3. Click Commit to upload the changes to source control.

For more information, see Commit changes.

Undo changes

The Undo operation discards uncommitted changes made to database objects or static data.

In the Local changes section:

1. Select the changes you want to revert.

2. Optional: Enter a comment in the commit message field.

3. Click Undo.

Get latest changes

The Get Latest operation retrieves updates from the remote repository to synchronize your local database copy.

In the Remote changes section:

1. Review the available updates.

2. Select the objects you want to update.

3. Click Get Latest.

For more information, see Get the latest version.

Resolve conflicts

The Resolve a conflict operation addresses overlapping changes made by multiple developers to the same database object.

When conflicts appear in the Conflicts section, you can:

  • Click Get Remote to apply the remote version.
  • Click Get Local to retain your version.
  • Use the comparison pane to review the differences between versions.

For more information, see Resolve conflicts.

View the changes history

The View Changes document displays a history of all committed changes, including:

  • The author of each change.
  • The date and time of the commit.
  • The commit message.

You can also compare differences between any two selected versions.

For more information, see View Source Control history.

Link and manage static data

You can link static data to source control and manage it the same way as database objects. This includes:

  • Committing and undoing changes.
  • Resolving conflicts.
  • Viewing the history of changes.

For more information, see Link and unlink static data.

Work with multiple branches

dbForge Studio supports working with multiple Git branches. You can:

  • Link a database to a specific repository branch.
  • Commit changes to the selected branch.
  • Pull updates from the remote branch.
  • View change history per branch.

For more information, see Switch between branches.

Associate commits with issues

You can associate commits with issues in GitHub or Team Foundation Server (TFS). This allows you to close linked issues automatically when changes are committed.

For more information, see Link commits to issues.