Thank you Helen for your quick and very helpfull response...

I had not looked at the IB Objects components for Delphi yet and it
looks like I'll now be able to acomplish my task.

Daryl

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 01:57 AM 31/03/2004 +0000, you wrote:
> >Greetings all!!
> >
> >I am splitting up a large table containing hundreds of thousands of
> >records onto multiple Firebird servers... What is the best way to
> >move a subset of records from a table on one server to a table in a
> >new database on another server?
> >
> >Is it possible to name the source server\database\table in the from
> >clause of an INSERT INTO... SELECT * From... Statement??
>
> No.
>
>
> >I'm trying desperately to avoid reading and writing one record at a
> >time.
>
> Use a datapump tool or component. I use the datapump utility in

IB_SQL for

> ad hoc transfers; I write a Delphi application (5 mins) using the
> TIB_Datapump component if I want to repeat the same transfer. It

uses a

> streaming mechanism to read from one connection and write to

another.

>
> /hb