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"
