How can I export DBeaver connection configurations?
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.
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.
On OSX (Mac) here:
/Users/${USER}/Library/DBeaverData/workspace6/General/.dbeaver/