how to convert data from oracle database to db2/udb
Please let me know the process to migrate data from Oracle database to DB2/ UDB.
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.
if you come across such tool plz let me know
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.
Originally Posted by anil_saab
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width