Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Open
  • Priority: Medium
  • Security: Public
  • Views: 51
  • 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
0
sajeev varghese
Asked:
sajeev varghese
3 Comments
 
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.
0
 
Tomas Helgi JohannssonCommented:
Hi!

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

https://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleappsondb2/

Regards,
    Tomas Helgi
0
 
theo kouwenhovenCommented:
XBintegrator can do cross convert of all DB's
See specs
0

Join & Write a Comment

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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