Unidump BackupQuery question

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Doraemon
Posts: 3
Joined: Mon 27 Jan 2014 07:16

Unidump BackupQuery question

Post by Doraemon » Mon 27 Jan 2014 09:18

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.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unidump BackupQuery question

Post by AlexP » Mon 27 Jan 2014 10:40

Hello,

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

Doraemon
Posts: 3
Joined: Mon 27 Jan 2014 07:16

Re: Unidump BackupQuery question

Post by Doraemon » Mon 27 Jan 2014 11:18

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!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unidump BackupQuery question

Post by AlexP » Mon 27 Jan 2014 11:38

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

Doraemon
Posts: 3
Joined: Mon 27 Jan 2014 07:16

Re: Unidump BackupQuery question

Post by Doraemon » Mon 27 Jan 2014 13:32

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unidump BackupQuery question

Post by AlexP » Wed 29 Jan 2014 07:51

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

Post Reply