Jason
Why not use DTS?
NEven
Jason Saggers wrote:
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
--
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062
New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland
Ph 620 1356
Fx 620 1336
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
