Re: Migration of ORACLE data base to DB2/400.

Simple import/export is the easiest and most reliable method. If you are
redefining tables on the target, you really need to work with a tool like
ERWin or ERStudio. Actually, it's a good time to completely define your DB
environment if that does not already exist and I would recommend either of
the above tools.

DB2 Magazine, Quarter 1, 2002 had a list of command and function differences
between Oracle and DB2.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"When I die, I want to die like my grandmother who died peacefully
  in her sleep. Not screaming like all the passengers in her car."

    - Author Unknown

----- Original Message ----- 
From: "Sudhakar_Annavaram" <Sudhakar_Annavaram@xxxxxxxxxx>
To: "'COBOL Programming on the iSeries/AS400'" <cobol400-l@xxxxxxxxxxxx>
Sent: Thursday, September 04, 2003 6:36 AM
Subject: Migration of ORACLE data base to DB2/400.


> Hello all,
>
> I have been working on COBOL/400, RPG/400 for past some years, but I got a
> new job to do now. I have to migrate ORACLE database to DB2/400, Could
some
> one suggest me "the ways and means" of migrating database from ORACLE
server
> to DB2/400. are there any tools used for this purpose?
>
> Your help is highly appreciated.
>
> Cheers
> Sudhakar
> **************************************************************************
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
> distribution or forwarding of any or all of the contents in this message
is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **************************************************************************
> _______________________________________________
> This is the COBOL Programming on the iSeries/AS400 (COBOL400-L) mailing
list
> To post a message email: COBOL400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/cobol400-l
> or email: COBOL400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/cobol400-l.
>