Sharing databases between projects within Intellij

DatabaseIntellij IdeaSharingProjects

Database Problem Overview

I use Intellij to inspect databases, run sql, view data in tables etc. This all works fine but the only thing I am missing is the ability to define these datasources once and view them in all my projects i.e. that I can share them between other projects and not have to redefine them for new projects. Is this possible in Intellij?

Database Solutions

Solution 1 - Database

Go to the Database tool window and click on the Data Source Properties button. Select the data source you want to make global. Click on the Make Global button in the tool bar above.

The Make Global button looks like this:

Make global button

Now you can use the data source from all your projects. However a global data source is not stored in the project files, so any other developers working on the same project will need to define their own data source.

Solution 2 - Database

The Make Global button is no longer green (Intellij Ultimate 2018.02).

It's located above the datasource list, as in the (crappy) screenshot.

enter image description here

Solution 3 - Database

In Intellij 2020.1, click on the Database view, then click on "Data Source Properties" (database with wrench icon). On the dialog that opens, click on "Make global", which is the 5th icon (screenshot below).

screenshot

Solution 4 - Database

In IntelliJ 2019.1, 2019.2 to share connection to DB with multiple projects:

  1. Open Database panel
  2. Datasource Properties
  3. Make Global

Solution 5 - Database

So how I did it on 2018.3 was to go to the Database tool window then right click on your datasource you want to copy then Database Tools -> Copy Datasource to Clipboard. In the Database window for the project you want to copy to click the + at the top left and it has an option to Import from Clipboard.

Solution 6 - Database

In IntelliJ 2019.3 to share connection to DB with multiple projects:

. Open Database panel . Data source Properties . Click the blueMake Global button

View this image to see where it is

Categories
Recommended Database Solutions
Recommended Intellij Idea Solutions

Previous Solution:

When should I use setDT() instead of data.table() to create a data.table?

Rdata.table

Next Solution:

Create Custom HTML Helper in ASP.Net Core

asp.net Coreasp.net Core-Mvc

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionNosView Question on Stackoverflow
Solution 1 - DatabaseBas LeijdekkersView Answer on Stackoverflow
Solution 2 - DatabaseEnaView Answer on Stackoverflow
Solution 3 - DatabaseAlex SantosView Answer on Stackoverflow
Solution 4 - DatabaseAndrey DobrikovView Answer on Stackoverflow
Solution 5 - DatabaseKeithView Answer on Stackoverflow
Solution 6 - DatabaseYohannes MollaView Answer on Stackoverflow