pwidf wrote:

>
> currently i select the relevant data from the source databases into
> an ado.net dataset, open a connection to the firebird db, create a
> table in the local firdbird database based on the schema of the
> dataset, then step thru each of the records in that dataset and
> generate an insert statement to insert the data into the firebird
> database, and finally close the connection.
>

"... generate an insert statement ..." seems time-consuming
Using a parameterized, prepared insert statement should be fast - maybe as
fast using an "external table".
(Never having used .net, vb, or c#, I don't know if this is applicable)

--
Aage J.