Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to migrate my oracle schema to db2. Any tool available for migration? Please help

share|improve this question
Since both ends are commercial software, shouldn't you talk to the people you are paying for support first? – symcbean Jul 19 '12 at 11:47
up vote 1 down vote accepted

IBM have a free tool called the IBM Data Movement Tool that can assist with this.

They have also published a very useful Redbook that can probably answer all of your questions and more. It's called: Oracle to DB2 Conversion Guide: Compatibility Made Easy

share|improve this answer
Check all the forums, articles and blogs about DB2 enablement: db2night show, "SQL tips for DB2 LUW" blog, developerWorks forums, wikis and artcles. – AngocA Aug 20 '12 at 7:06

I think Oracle's recently-acquired 'GoldenGate' product will allow you to do that.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.