search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
39.5k stars 3.42k forks source link

Export and Import data based on the query #35775

Open shrivatsahosabettu opened 4 days ago

shrivatsahosabettu commented 4 days ago

Is your feature request related to a problem? Please describe. Is there any option or I would like to have a option to export and import data based on the query. Currently if I need to do data transfer either I have to unload in one of the format of csv,xlsx, insert SQL, json etc.

Instead of this if there is option to transfer data based on the query with WHERE condition, that will be good. It will be nice I don't want to go through 2 step process of export in xls/csv/sql statements and then import.

E1izabeth commented 3 days ago

Hi, @shrivatsahosabettu You can select your query or put a cursor to the query you need, call the context menu, and choose Export form Query image

Then you can choose export to Database image

Is that what you need?

shrivatsahosabettu commented 1 day ago

@E1izabeth Yes this is exactly what I am looking for. Thanks for explaining with screen prints.

E1izabeth commented 1 day ago

Yes, it is

shrivatsahosabettu commented 13 hours ago

Thank you @E1izabeth, you can close this one then.