Moving data from one DB to another

[zd]

Hi! I need your help a little bit.

I have a database which stores a bunch of Word Documents as blob fields.

Since the size of the database grows rapidly, I want to introduce an archival function, which would copy the blob data from the main database to a separate database (along with some additional columns).

I suppose there is no SQL command in Firebird which would let me do this, so the question is:
How do I do this using IBDAC?

Is there a way to select the records from one dataabase then insert them into the other database? The blobs are between 10k and 100k on average, but there can be some large files too. (10MB max)

Thanks in advance:
Zd

[Plash]

You can try to use TCRBatchMove component which is located on Data Access page. It allows to copy data from one dataset to another dataset.