Quickest method to Transfer data from DB to another

Article View: borland.public.cppbuilder.database.ado

Article #1885

Back to borland.public.cppbuilder.database.ado Previous Next

#1885

From: Daniel Stevenson
Date: Mon, 12 Jan 2004 04:29

22 lines
1887 bytes

I'm currently looking into alternate (and hopefully faster) ways of moving
data from one database to another where the field names are the same in each
table and in some situations where some fields are not present within the
new database.

The original database has tables that are related to one another (ie. are in
master/detail relationship) and therefore data integrity needs to be
maintained

I currently move one record across to the new database at a time, then check
all other tables for records that are related to the master record and copy
those across before incrementing the master record, therefore keeping all
the records in their correct relationship.
I'm finding this method very slow especially with a database holding over
50,000 records.

I was wondering if there was a bulk method of copying data or an SQL method
that might be faster.

I'm currently using BCB6 with ADO and an Access database.

Thanks

Technical Details

Message-ID: <400222b2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!peernews-us.colt.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3afb015c65de2408,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-01-11 20:39:57 PST
From: "Daniel Stevenson" <d.stevenson@ocreage.com.au>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Quickest method to Transfer data from DB to another
Date: Mon, 12 Jan 2004 15:29:41 +1100
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 202.174.228.150
Message-ID: <400222b2@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1073881778 202.174.228.150 (11 Jan 2004 20:29:38 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!peernews-us.colt.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail