#DATAGRIP GITHUB HOW TO#
#DATAGRIP GITHUB INSTALL#
#DATAGRIP GITHUB SOFTWARE#
#DATAGRIP GITHUB DOWNLOAD#
#DATAGRIP GITHUB FREE#

In the software world, there has been a solid habit of using version control to keep track and manage source code changes and collaboration.You can clone a repository that you want to contribute to directly from DataGrip and create a new project based on it.įrom the main menu, choose Git | Clone. We have moved from centralized solutions like SourceSafe and TFS and now into using tools that distribute the management with Mercurial and Git.

#DATAGRIP GITHUB HOW TO#

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.

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. There is no reason why your database SQL scripts should not be under source control right next to your team’s application code. We will dig into VCS and give you some knowledge to keep that your database scripts and files backed up and up to date.

#DATAGRIP GITHUB DOWNLOAD#

You can download DataGrip now to see how your team’s database work can benefit. 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. By having versioned (explicit or dated) changes we can revert back to previous versions of the code if anything goes wrong. 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. Having backups of production data and scripts is a key for a well-run database, but it’s hard to keep the database history while not having issues like forgotten files throughout your hard drive.

You probably have a practice of overwriting your database’s backups with the latest data. The issue you will run into is losing good data that you may need in the future and also corrupting your database schema.

The other technique database professionals use is to save a date stamped backup in a folder, but that just leads to a mess with lots of files to manage.Ī database backup is just SQL code or other files that contain the data in a format the database engine can import, so why not handle it the same way you manage the rest of your code - in a source code system like Git? Setting this up is very simple so let’s walk through it.Īs with any version control system, Git was created to keep a historical look at source code and that includes database scripts and backups. You might be asking what makes it distributed? The key to Git is that is tracks your changes locally and remotely.Īs a distributed version control system it is aimed at speed, data integrity, and support for non-linear workflows. When you check your code into Git it stores those snapshot changes locally on your file system in a local repository. That way you can make many changes or back out of changes that you need to without affecting anyone else that also works with or depends on the code. When you are sure you want to make your changes available for others you can then “push” your changes to the remote repository. You can also “pull” other’s changes that have been pushed to the remote repository. That is a very simple look at Git but if you want more details please review the Git documentation and tutorials.

#DATAGRIP GITHUB INSTALL#

To work with Git or any other VCS system with DataGrip, we will need to install the plugin. To install the plugin go to File | Settings… and then select the Plugins option. Finally, select the Install JetBrains plugins… button. Working with Git in DataGrip Cloning a Project from GitHub You should get the Git Integration plugin showing first in the list that will allow you to install the plugin and restart DataGrip. With the Git plugin installed, you can now clone a remote repository to your local file system. Cloning is a command in Git that copies all the most updated file snapshots that exist on the remote server to the local you specify. In DataGrip, go to VCS | Checkout from Version Control | Git and you will be presented with the Clone Repository dialog.įor this example, we will clone the following Git Repository URL from GitHub to a local folder of your choosing (Parent Directory). GitHub is a Web-based Git version control repository hosting service. It is used for software code and other files such as database scripts we are showing with DataGrip. It offers all of the distributed version control and source code management functionality of Git. Īfter cloning the files that were copied to your local filesystem will be present in DataGrip’s File Tool Window.

#DATAGRIP GITHUB FREE#

To learn more about GitHub and/or to sign up for a free account go to.

Datagrip github