[DUG] Firebird copying tables

[Kyley Harris]

When you say one-by-one. do you mean you are committing each and every 
row as you save it?

I don't know if there is any faster way than

(* Psuedo code *)
d1.starttransaction
d2.starttransaction

d1.findfirstrow
while not d1.eof do begin
  d2.insertfromrow(d1)
  d2.next
end;

d1.commit
d2.commit

(* END *)

interbase does not support batch operations yet.
you could always convert the data into a text file of Insert statements, 
(* if there were no blobs *) and then write a script to execute them on 
the new table, but i doubt that would be faster.

Paul Lowman wrote:

>Whats the best way of copying selected records from one database/table to
>another database/table. I am currently doing it one by one and it is very
>slow ...  ;-(
>
>Cheers
>
>Paul Lowman
>
>_______________________________________________
>Delphi mailing list
>Delphi at ns3.123.co.nz
>http://ns3.123.co.nz/mailman/listinfo/delphi
>
>  
>