Home > IT Answers > Business Intelligence > Db2 to Oracle porting
Dpd0809
0 pts.
 Db2 to Oracle porting
Database Management Systems, DB2, Oracle
I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu

Software/Hardware used:
ASKED: October 7, 2004  3:37 PM
UPDATED: October 13, 2004  12:21 PM
RELATED QUESTIONS
Answer Wiki:
Sorry this is a late response but the major differences will be in the datatypes used and some of the objects such as sequences. This I learnt from going between Informix and oracle.
Last Wiki Answer Submitted:  October 13, 2004  5:39 am  by  Geoffreyhalleds   0 pts.
All Answer Wiki Contributors:  Geoffreyhalleds   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Sorry this is a late response but the major differences will be in the datatypes used and some of the objects such as sequences. This I learnt from going between Informix and oracle.

Geoffreyhalleds
 0 pts.
 

Sorry this is a late response but the major differences will be in the datatypes used and some of the objects such as sequences. This I learnt from going between Informix and oracle.

Geoffreyhalleds
 0 pts.
 

Oracle describes its tools for doing this conversion at
http://www.oracle.com/technology//tech/migration/toolkits/index.html

You may need to register, but this site is free. I have never done this particular migration myself.

Bertilak
 0 pts.