How can I export DBeaver connection configurations?

Question

I was hoping there is a way to export DBeaver connection configurations/properties from my old machine rather than having to go through the process of recreating each one. Does anyone know how to do this?

The DBeaver version on my old machine is 6.0.3, and the version on my new machine is 6.1.x.

Dinei · Answer 1 · 2020-11-07T17:47:13.233

I just migrated some projects from DBeaver 6.1.4 to 7.2.3 and the File > Export/Import options worked flawlessly.

The full workflow is:

File > Export, under "DBeaver", select "Project", click Next
Select the projects to export and click Finish
Copy the output file (by default, it is generated in home folder) into the machine where the projects will be imported
File > Import, under "DBeaver", select "Project", click Next
Select the file generated in the previous steps, it will automatically load the projects from it.
Select the projects to import, if there is any name conflict you can change the name of the imported project. Click Finish.

IMHO, very complete, easy and straightforward.

Update: after a few days of working, I realized some of the connections were not imported. I still don't know why, but it seems to be a bug. Just double check your connections after exporting and importing.

Thanks for the solution. It's good to use import/export functionality provided by Dbeaver instead of doing it manually by locating the Dbeaver data directory and using it in new Dbeaver setup. That directory might contain some unnecessary data e.g. logs, temporary files etc. If there is version mismatch, copying data manually might result in some abnormal behavior. — Tushar R., May 19 '22 at 07:46

score 59 · Answer 2 · edited Jan 22 '20 at 13:15

My experience on Windows 10 x64 for migrate connections from DBeaver 5.1.2 to DBeaver 6.1.5:

File | Export and File | Import functionality is (at least) not easy/clear. (Where are the "connection strings"? What should I export?)

So, I found these files:

DBeaver 5:

C:\Users\user-123\.dbeaver4\General\.dbeaver-data-sources.xml

(it was clearly updated from version 4)
DBeaver 6:

C:\Users\user-456\AppData\Roaming\DBeaverData\workspace6\General\.dbeaver\data-sources.json

So, I have to manually extract the data from XML and put in the JSON.
I hope you have the JSON configuration file for both 6.3 and 6.1.x.

Hope it helps.

score 52 · Answer 3 · edited Mar 02 '21 at 09:15

52

On OSX (Mac) here:

/Users/${USER}/Library/DBeaverData/workspace6/General/.dbeaver/

edited Mar 02 '21 at 09:15

dkb

4,389
4
36
54

answered May 19 '20 at 14:29

Hunor Kovács

1,062
9
16

1

Best answer for MacOS users; copying that folder did the trick! – GlauberMD Oct 22 '21 at 21:14
My needs was about the transfer all data from macos to linux, this did the work and I don't have to reconfigure nothing. – Matteo Gaggiano Mar 12 '23 at 12:11

score 39 · Answer 4 · answered Feb 05 '20 at 08:27

39

On Ubunutu, For Dbeaver 6, it is found in

$HOME/.local/share/DBeaverData/workspace6/General/.dbeaver

answered Feb 05 '20 at 08:27

nitzien

1,117
9
23

score 21 · Answer 5 · answered Dec 04 '19 at 11:23

21

For Microsoft Windows users the files can be found under:

C:\Users\your_user_name\AppData\Roaming\DBeaverData\workspace6\General\.dbeaver

answered Dec 04 '19 at 11:23

Marcell

809
8
23

Thanks, this helped me find the file. However, there is something else at play here... because DBeaver just started up without showing my connections, that were still visible in this .dbeaver file. I think there is some sort of correlation with project folders too, but a missing or moved project folder seems to lead to issues with not showing connections? – Nij Oct 21 '20 at 05:57

score 12 · Answer 6 · answered Jun 13 '19 at 15:17

12

DBeaver connections are stored in file .dbeaver-data-sources.xml, in DBeaver workspace, which is in %{HOME/.dbeaver4/General/ by default.

answered Jun 13 '19 at 15:17

Nifriz

1,033
1
10
21

Consule · Answer 7 · 2021-02-11T18:00:46.670

9

In my case the path is:

C:\Users\user\AppData\Roaming\DBeaverData\workspace6\General\.dbeaver

If the folder .dbeaver does not exist in a fresh installation you will need to create.

The beaver version: 7.3

edited Feb 11 '21 at 18:00

answered Feb 11 '21 at 17:52

Consule

1,059
12
12

ivoroto · Answer 8 · 2020-11-18T08:11:27.313

8

connections are now stored in a file named data-sources.json as you can check here

on my Ubuntu I lost my connections cause I downloaded the new version using snap

I solved it just copying that file from old path ~/.local/share/.DBeaverData/workspace6/General/.dbeaver/

to my new path ~/snap/dbeaver-ce/90/.local/share/DBeaverData/workspace6/General/.dbeaver

edited Nov 18 '20 at 08:11

answered Nov 18 '20 at 08:00

ivoroto

925
12
12

score 7 · Answer 9 · answered Jul 19 '20 at 09:28

7

Ubuntu 20.04, Snap installed: Dbeaver version: 7.1.2

Connections: ~/snap/dbeaver-ce/61/.local/share/DBeaverData/workspace6/General/.dbeaver/

Scripts: /home/shiwakant/snap/dbeaver-ce/61/.local/share/DBeaverData/workspace6/General/Scripts/

answered Jul 19 '20 at 09:28

Shiwakant Bharti

362
4
8

score 2 · Answer 10 · answered Jan 01 '21 at 13:26

2

I've just tried to move configuration for dbeaver 7.3.1 from one win machine to another, and if you copy&paste folder:

C:\Users\your_user_name\AppData\Roaming\DBeaverData\

you will get everything works quite smoothly

answered Jan 01 '21 at 13:26

jkarisik

31
1
3

score 2 · Answer 11 · answered Jan 21 '21 at 21:24

If you're using the Windows Store DBeaver CE Application on Windows 10 the workspace folder is different because of the app sandboxing and looks like this:

C:\Users\<USERNAME>\AppData\Local\Packages\DBeaverCorp.DBeaverCE_<SANDBOXING_HASH>\LocalCache\Roaming\DBeaverData\workspace6\

Then you can follow the Wiki instructions here:

https://dbeaver.com/docs/wiki/Admin-Manage-Connections/

Joseph · Answer 12 · 2023-08-25T01:15:35.940

1

On Windows, just copy these folders and files from the location %APPDATA%\DBeaverData\workspace6\General:

.dbeaver\
Scripts\
.dbeaver-data-sources.xml

Paste it at the target (a new installation of DBeaver doesn't have the above file and folders). The connections will appear and work. I just tested this a few minutes ago and wanted to document it.

edited Aug 25 '23 at 01:15

answered Jun 23 '23 at 02:06

Joseph

2,155
6
20
32

In my windows, %APPDATA% already include the "\Roaming" path, so, the path should be %APPDATA%\DBeaverData\workspace6\General – Raymond Chiu Aug 16 '23 at 02:12
ur right, I have edited the path to reflect it – Joseph Aug 25 '23 at 01:15

score 0 · Answer 13 · answered Jul 03 '20 at 01:28

DBeaver 6.1.3+

+project connections in the file:C:\Users\ [USER]\AppData\Roaming\DBeaverData\workspace6\General.dbeaver\data-sources.json

+All secured information files: C:\Users\ [USER]\AppData\Roaming\DBeaverData\workspace6\General.dbeaver\credentials-config.json

How can I export DBeaver connection configurations?

13 Answers13