Export and Import data based on the query

[shrivatsahosabettu]

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]

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

Then you can choose export to Database

Is that what you need?

[shrivatsahosabettu]

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

[E1izabeth]

Yes, it is

[shrivatsahosabettu]

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