how to convert data from oracle database to db2/udb

Hi

Please let me know the process to migrate data from Oracle database to DB2/ UDB.

Regards
Anil

There are some tools available who can do this.
If you intend not to use any tool you may have to do something like this,Never done this though, but a thought. You can write a program in any language perl/java to select data from Oracle and then insert it into DB2 tables.

thanks,

if you come across such tool plz let me know

Quote:

---

Originally Posted by anil_saab

Please let me know the process to migrate data from Oracle database to DB2/ UDB.

---

Check the Red Books, IBM documentation is generally very good but when it comes to migration in the IBM direction I can tell you it is awesome.

Dear Anil,

Check these out, might help:

http://www-01.ibm.com/software/data/db2/migration/mtk/
http://www.swissql.com/products/orac...le-to-db2.html

Regards,
Paresh