How can I export DBeaver connection configurations?
DbeaverDbeaver Problem Overview
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.
Dbeaver Solutions
Solution 1 - Dbeaver
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.
Solution 2 - Dbeaver
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.
Solution 3 - Dbeaver
On OSX (Mac) here:
/Users/${USER}/Library/DBeaverData/workspace6/General/.dbeaver/
Solution 4 - Dbeaver
On Ubunutu, For Dbeaver 6, it is found in
$HOME/.local/share/DBeaverData/workspace6/General/.dbeaver
Solution 5 - Dbeaver
For Microsoft Windows users the files can be found under:
C:\Users\your_user_name\AppData\Roaming\DBeaverData\workspace6\General\.dbeaver
Solution 6 - Dbeaver
DBeaver connections are stored in file .dbeaver-data-sources.xml
, in DBeaver workspace, which is in %{HOME/.dbeaver4/General/
by default.
Solution 7 - Dbeaver
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
Solution 8 - Dbeaver
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/
Solution 9 - Dbeaver
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
Solution 10 - Dbeaver
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
Solution 11 - Dbeaver
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
Solution 12 - Dbeaver
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: