Re: DB2 to Oracle -- MIDRANGE-L

The object of the exercise is to retire YOU...retirement liability etc.....are you in denial?

"Weatherly, Howard" wrote:

You might try net8 or some such, we are going to use DataJoiner mostly because we know DataPropagator Relational and know it will work long after the people forcing us to Oracle are forced to retire because of this major case of blatant stupidity.
-----Original Message-----
From: Billy Rowe [mailto:billyrowe@usa.net]
Sent: Thursday, June 28, 2001 14:52
To: midrange-l@midrange.com
Subject: Re: DB2 to Oracle
>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
+---

--
Best Regards
Ken Shields
Home phone: 905 404-2062
Bus phone 905 725-1144 (326)
+--- | 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 +---