Sharing databases between projects in Intellij

Question

I use Intellij to check databases, run sql, view data in tables, etc. It all works fine, but the only thing I miss is the ability to define these data sources once and view them in all my projects, that is, I can share them between other projects and do not need to redefine them for new projects. Is this possible in Intellij?

Answer 1

In the properties of the data source, select the data source and click the Make Global button (field with a green arrow). Now you can use the data source from all your projects. However, the data source is no longer stored in the project files, so any other developers working on the same projects will need to define their own data source.

Answer 2

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

It is located above the list of data sources, as in the (crappy) screenshot.

Answer 3

So, as I did in 2018.3, it go to the database tool window, then right-click on the data source that you want to copy, then Database Tools → Copy data source to clipboard. In the database window for the project that you want to copy, click + in the upper left corner and it has the option to import from the clipboard.

Answer 4

In IntelliJ 2019.1, 2019.2 for sharing a database connection with multiple projects:

1. Open database panel
2. Data Source Properties
3. Make global