How to execute a SQL script in DBeaver?

dbeaver
Luís de Sousa picture Luís de Sousa · Feb 2, 2017 · Viewed 92.5k times · Source

I have a number of .sql files that I wish to execute through DBeaver. Traditional database development programmes allow the user to edit and run SQL scripts (totally or partially) in the same window, but this is not obvious with DBeaver.

When I open a .sql script some drop down boxes in the button bar appear, that seem to serve as connection selectors. But none of the connections I have defined appear in these drop down boxes. It is possible to open a SQL console on database objects in the Database Navigation view, but not on SQL scripts.

How can I execute a SQL script, totally or partially, against a particular database connection with DBeaver?

Answer

simhumileco picture simhumileco · Jul 21, 2017

For larger files, the more optimally it is edit the .sql file in an external editor and then in DBeaver:

  • right-click on your DB
  • chose Tools / Execute script
  • load your .sql file
  • click Start.

This approach is generally more convenient and faster for large files.


To do this without an external editor, you must:

  • set your DB in Active datasource select
  • load your file File / Open file ...
  • run the whole script e.g. using a shortcut Alt+X.

Related questions

Export result set on Dbeaver to CSV

Normally I use Dbeaver for windows and always export my result set like this: Run my query --> select the result --> export the result set --> select export to clipboard --> done This step by …

Read More
Recover DB password stored in my DBeaver connection

I forgot the password of a dev instance (irresponsible.. yeah, I am working on it). I have the connection saved in my DBeaver with the password. I am still able to connect using that connection. DBeaver is not showing it …

Read More
DBeaver, export from database Postgres, table structure (properties) into file .txt

I have little problem with DBeaver. I want to export my structure from each table from database in file .txt. I found how to export all data but I don't need this data, just table structure. If you have some …

Read More