|
Hi, I have run into a small issues. I have a piece of code with
basically dose some archiving of data in one database to another. I have a large number of rows (approx 20 million) across
about 20 tables to move, and was wondering what would most likely be the
quickest way. I am currently using the SqlConnection and SqlCommand
structure (out of habit) using a select from and insert into commands with
parameters, however was considering using the bdc ones as they seems to product
a quicker result. The DB is MSSQL 7. This seems a slow way, but currently wondering If building a
stored procedure that does the same based on a unique id passed to it would be
quicker (however to two databases are on different servers). Jason Saggers |
_______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
