Contents

Link a database to a Git repository in Bitbucket

Bitbucket is a web-based platform used for source code management (SCM) and version control. It supports distributed version control systems, with a primary focus on Git repositories. Developers can collaborate on projects, manage source code, track and revert changes, as well as work on different branches simultaneously. Bitbucket offers a wide range of services, including code review, issue tracking, continuous integration and deployment, and integrations with other software development tools such as Jira and Confluence.

Prerequisites

• Install Git for a Windows client on the machine where you’ll be version-controlling a database
• Have a Bitbucket account
• Create a Git repository in your Bitbucket account

The guide covers the following topics:

• Step 1: Clone a repository using the command line
• Step 2: Link a MySQL database to source control
• Step 3: After linking to Git

Step 1: Clone a repository using the command line

1. Create an empty folder on the disk of your computer to store the local repository. For example, a bitbucket folder stored on the drive D.

2. Sign in to your Bitbucket account, navigate to Repositories on top of the page, and then select the repository you want to clone to your computer.

3. In the upper-right corner of the repository page, click Clone.

4. In the Clone this repository window that opens, select either HTTPS (default option) or SSH as the connection protocol, and copy the clone command with the repository URL. HTTPS, which is a default option, supports user/password authentication, and SSH - public key authentication. In our example, we use HTTPS.

Note

When cloning over SSH from a Bitbucket repository, the user’s public key needs to be added to the Bitbucket account and saved on the local computer they are using to clone the repository. This allows for secure authentication between the local computer and the Bitbucket server.

5. Start Windows Command Prompt (CMD). If you need to change the disk drive and navigate to the empty folder you created, in the Command Prompt, use the cd command.

6. In the Command Prompt, paste the clone command with the repository URL to create a cloned copy of the repository in the local folder (bitbucket in our case). Since the HTTPS protocol has been selected, you will be prompted to enter the username and password to your BitBucket account.

Note

Specify a dot at the end of the command to clone the repository to the folder you have created. Otherwise, another subfolder will be created.

If you didn’t add any files to the repository when you created it for the first time, follow these steps:

7. Execute the git commit --allow-empty -m initial command.

8. Execute the git push command to push the cloned repository to Bitbucket.

Step 2: Link a MySQL database to source control

After you cloned the remote repository to the folder on your local computer, you can link the database to source control using the Source Control tool available in dbForge Studio for MySQL.

1. In Database Explorer, right-click the database you want to link to source control and select Source Control > Link Database to Source Control.

2. On the Link page of the Link Database to Source Control dialog that opens, click + in the Source control repository field.

3. In the Source Control Repository Properties dialog that opens, do the following:

• From the Source control system dropdown list, select Git as a source control system.
• In the Repository folder field, click More to add the repository folder. In the Select Folder window that opens, select the folder, which is a local copy of your Bitbucket remote repository, and then click Select Folder.
• Optional: In the Repository name field, you can change the name of the repository folder.
• Optional: Click Test to verify that the database has been connected to source control.
• Click OK to close the Source Control Repository Properties dialog.

4. In the Link Database to Source Control dialog, select a database development model: shared or dedicated.

5. Click Link to establish the connection between the database and repository.

The Refresh progress window opens automatically showing the stages of the refresh operation. The linked database gets the following icon in Database Explorer:

Step 3: After linking a database to the BitBucket repository

If you are the first person to link this database, add the database objects to source control in an ‘initial commit’: go to the Local changes section, select the objects, and click Commit. For more information, see Commit changes.

If you linked a database that is already in source control, update your database to the latest version: go to the Remote changes section, select the objects, and click Get Latest, which is available only in the dedicated model. For more details, see Get the latest version.

Want to Find out More?

• Previous
• Next