Dear Neven,
Thanks. I will try it.
Best Regards
Leigh
----- Original Message -----
From: "Neven MacEwan" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Friday, November 03, 2000 4:41 PM
Subject: Re: [DUG]: Best way to copy data from one database to another
database using ADO
> Leigh
>
> Blobs are going to be a problem and so is RI (esp self referencing)
>
> If you use ADO you can still use the logic I outlined
>
> 1/ Drop Target tables if they exist*
> 2/ Create Target Tables without RI, PK, Triggers or Indexes*
> 3/ Use ADO (Cantu type algorithm) to copy in data
> 4/ Create PK's, triggers and Indexes*
> 5/ Run fixup scripts*
> 5/ Update RI*
>
> The items marked * will have to be specific for the target DB
> But I don't think it will be quick! (esp blobs)
> Bulk inserting will significantly faster without RI, PK, Triggers or
Indexes
> especially on large tables
>
> HTH
> Neven
>
> > I am sorry that I have not made it clear. One off means that user do
copy
> > procedure, not developer, and this application is a product offer to our
> > customers.
> >
> > By the way, I tried dts, due to different column type in different
> database,
> > actually that DTS failed on lots of tables, i.e. Blob field in Oracle is
> > called LONG RAW, in SQL Server called image, in interbase called Blob.
> > And I suspect that self reference table also cause the problem. In DTS,
> that
> > error message just so brief, I can not get the real cause for failing.
> > And I also noticed that DTS use VBScript engine to do data
import/export,
> I
> > suspect that it would be very slow, row by row, column by column, all
are
> > interpreted. So even DTS works correctly, but compare to native compile
> > code, it should not be a good candiate.
> >
> > Best Regards
> > Leigh
> >
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
