Personally I would use stored procedures with direct DB-DB connectivity.
INSERT INTO ServerX.Database..Table
FROM #MyTable
is a hell of a lot faster than INSERT INTO Table VALUES (:Parm1, :Parm2,
.....)
$0.02
Stephen
----- Original Message -----
From: "Jason Saggers" <[EMAIL PROTECTED]>
To: "NZ Borland Developers Group - Delphi List" <[email protected]>
Sent: Tuesday, August 09, 2005 10:05 AM
Subject: RE: [DUG] At a bit of a loss re SQL Archiving via Code
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:[EMAIL PROTECTED]
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
[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
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
