Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

It is easy to accidentally close these views without a clear way to restore them. To restore them quickly, choose Window/Open Perspective/Other/DBeaver (default)

Automating SQL script to run on a schedule

  1. Right click on DBeaver project folder that contains the script to be automated and choose Set Active Project
  2. Create new task, choose SQL script, choose the sql script file to run, choose Connection to use
  3. Use the Scheduler to run the task on a given schedule in both DBeaver and Windows Task Scheduler
  4. If you don't see the file you created in one of the local schemas right away, right-click on the Connection used and choose Refresh