Sharing databases between projects within Intellij

Question

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?

Possible duplicate of [Can I share settings for IntelliJ Idea across different projects?](https://stackoverflow.com/questions/5313946/can-i-share-settings-for-intellij-idea-across-different-projects) — Code-Apprentice, Sep 22 '17 at 15:06

Bas Leijdekkers · Accepted Answer · 2019-10-29T18:48:22.610

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.

score 26 · Answer 2 · answered Aug 06 '18 at 16:29

26

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

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

answered Aug 06 '18 at 16:29

Ena

3,481
36
34

2

In Intellij Ultimate 2018.2.5 I could not find it – Rajesh Goel Oct 31 '18 at 21:28
1

This icon is present in "Data Sources and Drivers" window – chill appreciator Jan 01 '20 at 19:11

score 11 · Answer 3 · edited Jul 27 '20 at 19:31

11

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

edited Jul 27 '20 at 19:31

Matt Ke

3,599
12
30
49

answered Jul 27 '20 at 18:18

Alex Santos

111
1
3

score 3 · Answer 4 · answered Jul 29 '19 at 13:58

3

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

answered Jul 29 '19 at 13:58

Andrey Dobrikov

457
4
20

score 1 · Answer 5 · answered Jan 15 '19 at 19:41

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.

score 0 · Answer 6 · edited Mar 20 '20 at 08:54

0

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

edited Mar 20 '20 at 08:54

Hans Keﬆing

38,117
9
79
111

answered Mar 20 '20 at 08:47

Yohannes Molla

1
1

Sharing databases between projects within Intellij

6 Answers6

Linked