Devart Forums

I am trying to export data from a database via a query.

Unfortunately the table I am trying to export is large ( > 3 GB ) and consequently I get an out of memory error.

The data is retrieved on a seperate thread.

Is it possible to free the data written to file?
And could I check the size of the data already retrieved?

That way I could pause the thread and wait for some of the data to be written to file before continuing.

Try to use the TMSDump component to export data from a database.
TMSDump serves to store data from tables or editable views as a script and to restore data from a received script.

Can't use the TMSDump component since I need to write out in a specific format.

However reviewing the TMSDump backup method pointed me in the right direction.

I've taken the query off the thread and set UniDirectional to True. The help file pointed out this turns caching off.

It is good to see that this problem has been solved. If any other questions come up, please contact me.