Committing changes

dbForge Source Control makes it easy to update your source control repository by committing changes.

The objects you are working on get a special label in Object Explorer:

Source Control label

To commit a change

1. In Object Explorer, right-click a required linked database or a specific database object.

2. On the shortcut menu, point to Source Control and click Commit.

Committing changes via SSMS shortcut menu

The Refresh dialog box opens automatically, showing the stages of the refresh procedure.

Refresh

3. Once the refresh is complete, Source Control Manager opens. In the Local changes section, select the objects and/or static data you want to commit.

If you select not all related objects, but only one, then after clicking Commit, you will see the following window with the suggestion to include all affected objects:

Dependencies window

4. In the text box, write a comment describing your commit. This will help other developers understand its purpose.

Committing changes

As you can see in the screenshot above, the Source Control grid contains the following columns:

Column Description
Change Type For Commit:
Actions to be applied to the object or static data in the source control repository; these include Add (the object or data will be added); Modify (the object or data will be modified); Remove (the object or data will be removed).
For Undo:
Actions to be applied to the object (but not to static data) in the linked database; these include the following action for database objects: Add (the object will be dropped); Modify (the object will be altered); Remove (the object will be created). For more information about how to undo changes, see Undoing changes.
Type The type of the object
Name The name of the object that will undergo changes; a <name> (Data) construction refers to static data
Owner The schema or database in which the object was created

Note

The Comment text box is not available when a database is linked to a working folder.

5. Click Commit. The Commit dialog box opens, showing the stages of the commit operation. When all the stages are completed, click OK to close the dialog box.

Committing changes

Now source control repository is updated with your local changes.