Black Friday is here! Get up to 30% off on Devart products!
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

MySQL Source Control: Manage Database Versions
in the Easiest Way

Source Control is an integrated feature of dbForge Studio for MySQL that was designed to simplify and streamline database version control, providing you with support for all popular version control systems, including Azure DevOps Server (previously known as Team Foundation Server), Apache Subversion (SVN), TFVC, Git (including GitHub, GitLab, and Bitbucket), Mercurial (Hg), Perforce (P4), and SourceGear Vault.

Using Source Control, you can easily take care of the following tasks:

  • Version-control MySQL schemas and static table data
  • Manage database versioning under the dedicated or shared development model
  • Commit and revert changes with dependency awareness
  • Perform fast comparison of database versions
  • View conflicts and resolve schema and data inconsistencies visually
  • View the history of changes
  • Automate MySQL database development within a DevOps cycle

Select the preferred MySQL version control system

First of all, make sure you have established a connection to the database that you want to link to Source Control. Then, in Database Explorer, right-click that database, select Source Control > Link Database to Source Control from the shortcut menu. You will be greeted by the Link Database to Source Control dialog, where you will be able to specify the version control system and repository of your choice.

You also need to pick a development model: either dedicated or shared. In the former case, you will have your own local copy of the database; in the latter case, you and your colleagues will work with the same shared copy.

Select a version control system

Link your database to a working folder

In case you want to version-control your database locally, you can select a working folder as your repository. A working folder is a set of SQL script files that represent your database. After linking, you will be able to version-control your working folder with a multitude of operations available from Source Control Manager.

Link a database to a working folder

Handle changes in Source Control Manager

Source Control Manager delivers all the tools you might need to version-control your MySQL databases with ease:

  • Commit local changes to your remote repository
  • Add comments to your commits
  • Get the latest changes from the repository
  • Resolve conflicts
  • Compare your local database version with the remote one to detect and view differences
Source Control Manager

Link static data

MySQL Source Control allows version-controlling static table data, committing, tracking, and reverting changes, resolving data conflicts, and maintaining the integrity of your MySQL databases.

If you need to link static table data to your repository, right-click the database that contains it and select Source Control > Link/Unlink static data from the shortcut menu.

Link static data

View the history of changes in MySQL version control

To ensure full transparency and quick identification of potential issues, you can address the Changes History document.

  • View the history of changes for an entire MySQL database or for separate database objects
  • View the details of each commit, including revision ID, date, author, and comments
  • Check the list of objects that were modified in each commit
  • Identify DDL differences for each database object
  • Compare the local version of an object with the remote one
Changes History

How to use MySQL version control for efficient collaboration

Want to see it all in action? Check this video and learn how to select and link MySQL databases to Source Control, set up a repository, as well as view, commit, and manage changes.

FAQ

Conclusion

With all of these features at hand, version control of MySQL databases has never been easier. And of course, there is so much more to dbForge Studio for MySQL that is worth noting, from coding assistance and debugging to visual query building and optimization, from database design and management to data analysis and reporting.

You are free to explore dbForge Studio during a free 30-day trial, so don't hesitate to download and give it a go today!

dbForge Studio for MySQL

Your ultimate IDE for MySQL and MariaDB development and management

Download

Availability in the editions of dbForge Studio for MySQL

Feature

Enterprise
Professional
Standard
Express
Source Control
Yes
None
None
None

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.