• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 73
  • Last Modified:

Which is the best tool to convert procedures from Oracle to IBM Database

I need suggestion around tools that can be used to convert sql, procedures from Oracle DB to IBM DB2 database.
Thanks in advance
sajeev varghese
sajeev varghese
3 Solutions
Kent OlsenData Warehouse Architect / DBACommented:
Hi sajeev,

As far as I know, there is no seamless "Convert" process.  

If the conversion is to be simply a move of the schema (and data) from Oracle to DB2 the easiest approach would be to create the database on the DB2 side, export the data into a flat file from Oracle, and import the data into DB2.  But there are still quite a few things that you'll have to do by hand.

-  There are different names for similar data types.  (VARCHAR vs VARCHAR2) etc.  The Oracle datatypes will need to be converted.
-  If Oracle tables use a SEQUENCE and TRIGGER to implement an IDENTITY, you'll need to convert them.
-  Date and Time values and handling are considerably different between to two databases.
-  Character sets may be a concern.
-  Procedures and views may need some modification, packages certainly will.

Probably the easiest way to do this is to link the two servers and let the ODBC/JDBC connectors do most of the heavy lifting.
Tomas Helgi JohannssonCommented:

DB2 LUW 10.1 and newer have a good Oracle application compabiltiy support to easilly transfer Oracle application (Oracle PL/SQL etc) to DB2.


    Tomas Helgi
MurpheyApplication ConsultantCommented:
XBintegrator can do cross convert of all DB's
See specs
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now