copy database setup from one project to another

Question

I am using intllij and every now and then I have to setup a new project which uses the same or similar datasources to a previous project.

Is there a simple way to copy them across?

Already asked and answered here https://stackoverflow.com/questions/41934918/sharing-databases-between-projects-within-intellij/57255435#57255435 — Andrey Dobrikov, Jul 29 '19 at 14:00
@AndreyDobrikov only 3 1/2 years after this question. just saying — BevynQ, Aug 01 '19 at 02:54
Well I looked for an answer myself only yesterday, and saw your post, just saying. — Andrey Dobrikov, Aug 01 '19 at 03:50

BevynQ · Answer 1 · 2016-09-15T23:29:14.677

9

Under the datasource properties there is a scope in the top right corner.

Change it from PROJECT to IDE

Looks like the interface has changed there is now this button to use it will move the data source from Project Data Sources to Global Data Sources. Using it on a Global Data Source will move it to Project Data Sources

more information at jetbrains

edited Sep 15 '16 at 23:29

answered Jul 16 '13 at 02:10

BevynQ

8,089
4
25
37

2

Looks like the UI for this has changed. In 2016.2.2 its now a "Make Global" button in datasource properties that seems to do the same thing. – Michael Haefele Sep 15 '16 at 16:52

score 2 · Accepted Answer · answered Aug 29 '18 at 08:57

2

You can either move a data source to a shared, global data source, or you can copy them as a separate data source (added somewhere in 2017). The first option will keep the consoles etc. shared, the second one will not.

To copy a data source, go to the context menu → Database Tools → Copy Data Source to Clipboard. Then in the other project go the context menu → New → Import from Clipboard.

answered Aug 29 '18 at 08:57

Jan Fabry

7,221
2
36
41

In fact this should be accepted answer! Does exactly what was asked. – Alex Povar May 17 '19 at 18:41

copy database setup from one project to another

2 Answers2