Devart Forums

Hi,

I want to do a file dump of a SQL statement. Therefore, I'm searching for something like Unidump.BackupQueryToFile.

I know, I can do a normal backup with Unidump.BackupQuery and then do a Unidump.SQL.SaveToFile, but I don't want to do this for large tables, because I have worries that this will eat up my memory...

Thanks for any suggestions!
Regards.

Hello,

To dump directly to a file, you can use the BackupToFile method.

Hi AlexP,

Thanks for your prompt response!
I know of BackupToFile method and I've used it already to dump whole tables, but is it possible to dump with this method also the result of specific SQL statements?

Thanks!

Yes, you can use your SQL query specifying it as the second parameter in the BackupToFile method.

I haven't noticed the second parameter in BackupToFile. I think that will do it!
Thanks for your kind support!

If you have any further questions, feel free to contact us.