Page 1 of 1

Export All Records from Query

Posted: Fri 04 Sep 2015 18:06
by 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

Re: Export All Records from Query

Posted: Mon 07 Sep 2015 11:04
by 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.