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
