Export Query Results to Another Database using DBeaver

In this post, we’ll export query results from one database to another using DBeaver. We’ll use the Community Edition 21.2.3.

Right-click the database you want to copy from.

Choose “SQL Editor” > “New SQL script”.

A tab will open on the right side. Write there your query. Press Ctrl+Enter or click the “Execute SQL Statement” icon.

On the results grid, right-click anywhere and choose “Export data…”.

Click “Next” on the dialog box that opened.

Choose the target container. (You can click the orange folder icon and choose from the databases list.)

Click “Next”, click “Next” again, and then click “Start”.