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.

Answer 1

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:

1. File > Export, under "DBeaver", select "Project", click Next
2. Select the projects to export and click Finish
3. Copy the output file (by default, it is generated in home folder) into the machine where the projects will be imported
4. File > Import, under "DBeaver", select "Project", click Next
5. Select the file generated in the previous steps, it will automatically load the projects from it.
6. 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.

Answer 2

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.

Answer 3

On OSX (Mac) here:

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

Answer 4

On Ubunutu, For Dbeaver 6, it is found in

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

Answer 5

For Microsoft Windows users the files can be found under:

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

Answer 6

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

Answer 7

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