[DUG] At a bit of a loss re SQL Archiving via Code

[Jason Saggers]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20050808/405b7dc0/attachment.html