× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: DB2 to Oracle
  • From: "Weatherly, Howard" <hweatherly@xxxxxxxxxxxx>
  • Date: Thu, 28 Jun 2001 16:27:16 -0400

Title: RE: DB2 to Oracle

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
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.