Page 1 of 1

How to Export and Import BLOB Data ?

Posted: Sat 07 Apr 2018 16:19
by luapfr
Hello I would like to know if there is any way I could export data from a whole table where I will have several different columns type among them. There are columns of the Type BLOB as I could expand the data of this table and then import by the component "IBCScript"

ru/viewtopic.php?t=13790

It looks like the component "TDADump" does what I need but I'm not finding it in the IBDac component palette
this component "TDADump" looks like it can export and import Blob Type data

how could I use it BackupQuery and Restore ?


   Thankful.

Re: How to Export and Import BLOB Data ?

Posted: Tue 10 Apr 2018 13:05
by ViktorV
IBDAC does not contain a component similar to TUniDump.
You can try using the TCRBatchMove component, which allows you to transfer data between different datasets. You can get more detailed information about it in our documentation: https://devart.com/unidac/docs/index.ht ... chmove.htm
Also, you can independently implement the functionality you need. You can get the necessary information about working with BLOB fields using our IBDacDemo project, on the 'InterBase specific\BlobPictures' tab, which you can find in the directory: %IBDACDemos%\IBDacDemo, where %IBDACDemos% is the path where IBDAC Demo projects are installed on your computer.

Re: How to Export and Import BLOB Data ?

Posted: Wed 11 Apr 2018 18:14
by luapfr
you say you do not have the component "TIBCDump"
but in the IBDac update history it talks about patches in component
and on top of that I was able to find the component class

Has it ever existed in the Past ?

https://www.devart.com/ibdac/revision_history.html

5.3.7 29-Apr-14
Bug with the Dump component when UseUnicode = True is fixed

5.2.6 19-Feb-14
Bug with percentage count in the OnRestoreProgress event of the TDADump class is fixed

I think it would be interesting if you put it back into IBDac.

Re: How to Export and Import BLOB Data ?

Posted: Fri 13 Apr 2018 07:38
by ViktorV
The TIBCDump component does not exist and never existed. All of our DAC products use the same basic core, and the specified information in the help refers to the basic level, therefore, got into the IBDAC help.

Re: How to Export and Import BLOB Data ?

Posted: Fri 13 Apr 2018 10:40
by luapfr
I understand, however, I am giving you a suggestion to include this excellent component in IBDac in the future.

From an analyzed one would be very good for IBdac this powerful component.

Re: How to Export and Import BLOB Data ?

Posted: Fri 13 Apr 2018 10:51
by ViktorV
If you want us to implement the feature, please post it at our user voice forum: https://devart.uservoice.com/forums/104 ... e-firebird. If the suggestion gets a lot of votes, we will consider the possibility to implement it.