Re: DB2 to Oracle

[Billy Rowe <billyrowe@xxxxxxx>]

>Does anyone know of any product (other than IBM's DB2Connect) that will 
>allow the transport of data from a DB2 database to an Oracle database?

>(The aim is to move an entire database from AS400 to Oracle/Sun - not my 
>decision sadly, or it would stay where it is).

We are currently in a 4 year plan of consolidating our platforms to a ORACLE
database, so we have created a DataBase Sychronization process for
sychronizing data between DB2(AS400) and ORACLE.

We use CPYTOIMPF to build a flat file of all our tables with a delimiter
between each table, the columns are TAB delimited.  We then FTP the
BIG file instead of 1 import file at a time to the SUN box running ORACLE.

You can do something similar and use SQL Loader to load the data into your
ORACLE database.

HTH


____________________________________________________________________
Get free email and a permanent address at http://www.amexmail.com/?A=1
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---