copying BLOB fields between databases

Thread View: borland.public.interbase.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by James Ponder Tue, 10 Dec 2002 02:22

#11189

Author: James Ponder
Date: Tue, 10 Dec 2002 02:22

17 lines
1736 bytes

I need to copy selected BLOB fields from one database to another.

Suppose:

         db1.gdb and db2.gdb are the databases.

         tbl1 is a table in db1.gdb which contains a BLOB field.

         tbl2 is a table in db2.gdb which also contains a BLOB field.

I need to select specific records from tbl1 and copy them to tbl2.

I am using Delphi 6 Pro and Interbase 6.  I have played with 
TIBBlobStream but can't get it to work.  Any help would be appreciated. 
  Answers to my email (jhponder@mindspring.com) would also be 
appreciated as I have difficulty accessing the newsgroup on any regular 
basis.  Thank you.

Re: copying BLOB fields between databases

#11194

Author: Bj�rge S�ther
Date: Tue, 10 Dec 2002 10:50

27 lines
2017 bytes

"James Ponder" <jhponder@mindspring.com> skrev i melding
news:3df54f99$1@newsgroups.borland.com...
> I need to copy selected BLOB fields from one database to another.
>
> Suppose:
>
>          db1.gdb and db2.gdb are the databases.
>
>          tbl1 is a table in db1.gdb which contains a BLOB field.
>
>          tbl2 is a table in db2.gdb which also contains a BLOB field.
>
> I need to select specific records from tbl1 and copy them to tbl2.
>
> I am using Delphi 6 Pro and Interbase 6.  I have played with
> TIBBlobStream but can't get it to work.  Any help would be appreciated.
>   Answers to my email (jhponder@mindspring.com) would also be
> appreciated as I have difficulty accessing the newsgroup on any regular
> basis.  Thank you.

have you set Stram.Position *after* read but *before* write ?
...see, after the srtram has read all data, it's located at end of stream,
and it will appear to have "no data left".

--
Bj�rge S�ther
bjorge@hahaha_itte.no

Re: copying BLOB fields between databases

#11195

Author: Stefano Giannini
Date: Tue, 10 Dec 2002 10:56

51 lines
2618 bytes

Hello,
why don't you use the IbDataPump utility?

you can download a free version from this site:
http://www.clevercomponents.com/downloads/index.asp

Interbase DataPump v 3.4 standalone application.



That's the guide to how to use the programm:
http://www.clevercomponents.com/products/datapump/dp-tour.asp#21

I used it to divide a 1.7Gbyte database into 6 others using blob fields too.

Bye,
Stefano Giannini



"Bj�rge S�ther" <bjorge@hahaha_itte.no> ha scritto nel messaggio
news:3df5c5eb$1@newsgroups.borland.com...
> "James Ponder" <jhponder@mindspring.com> skrev i melding
> news:3df54f99$1@newsgroups.borland.com...
> > I need to copy selected BLOB fields from one database to another.
> >
> > Suppose:
> >
> >          db1.gdb and db2.gdb are the databases.
> >
> >          tbl1 is a table in db1.gdb which contains a BLOB field.
> >
> >          tbl2 is a table in db2.gdb which also contains a BLOB field.
> >
> > I need to select specific records from tbl1 and copy them to tbl2.
> >
> > I am using Delphi 6 Pro and Interbase 6.  I have played with
> > TIBBlobStream but can't get it to work.  Any help would be appreciated.
> >   Answers to my email (jhponder@mindspring.com) would also be
> > appreciated as I have difficulty accessing the newsgroup on any regular
> > basis.  Thank you.
>
> have you set Stram.Position *after* read but *before* write ?
> ...see, after the srtram has read all data, it's located at end of stream,
> and it will appear to have "no data left".
>
> --
> Bj�rge S�ther
> bjorge@hahaha_itte.no
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads