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

[Neven MacEwan]

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
> Delphi at ns3.123.co.nz
> 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