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

[Jason Saggers]

Mainly because I would rather code it, but 2 because where are dealing
with multiple db's across multiple machines, that are very complex.

Also the information about which rows need to be transferred are not in
the tables that the rows being transferred are. This makes is easier to
code due to being able to store and retrieve large arrays, linked lists
etc...


Jason 

-----Original Message-----
From: Neven MacEwan [mailto:neven at mwk.co.nz] 
Sent: Tuesday, 9 August 2005 9:18 a.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] At a bit of a loss re SQL Archiving via Code

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
_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi