Export All Records from Query

[par20pinspot]

I am trying to export all records from the result of a query. I know that turning off pagination is one way, but the results of my query has >1 million rows. I'm sure I could do this outside of dbForge studio, but wondering if there is any other way. Thanks

[alexa]

You can create a view based on the query the result of which you want to export, then right-click the view in Database Explorer, select 'Export Data...' and complete the wizard.

This way there is no need to retrieve data to Data Editor prior to exporting it.