We can also have labels that track released versions of our database so that we can proceed to future development without losing our production code. By having versioned (explicit or dated) changes, we can revert back to previous versions of the code if anything goes wrong. If you are new to VCS or version control, just know that it is a way to track changes to one or more files and has the ability to track those changes with a version that can be referenced later when necessary.

You can download DataGrip now to see how your team’s database work can benefit. We will dig into VCS and give you some knowledge to keep that your database scripts and files backed up and up to date. There is no reason why your database SQL scripts should not be under source control right next to your team’s application code. With DataGrip’s inheritance from IntelliJ IDEA, we have the ability to use Git to store, manage edits, and allow a team to collaborate on projects that benefit everyone. While both centralized and distributed technologies have pros and cons, we will be looking at why database professionals need to use version control and how to do it with the popular tool Git. We have moved from centralized solutions like SourceSafe and TFS and now into using tools that distribute the management with Mercurial and Git. In the software world, there has been a solid habit of using version control to keep track and manage source code changes and collaboration.

Download idea datagrip