DBeaver How to Save Export Data Script

Question

DBeaver has excellent Import data/Export data tools, but is it possible to Save the export or import script rather than execute it immediately so that it can be executed at a later time?

I need to migrate a production database so I want to prepare all of the scripts beforehand and then execute them all when it's time to do the switch.

Answer 1

You can save your scripts from menu [SQL editor]->[Save SQL script].

Then in project panel you can create link on folder that contains your saved scripts or on script itself.

Also there is a Script Management guide on DBreaver Git wiki.

Answer 2

The file that contains all dBeaver tasks is a JSON file.

On my computer, it's located in

C:\Users\fred\AppData\Roaming\DBeaverData\workspace6\General\.dbeaver\tasks.json