Loading....

This note will detail the steps required to move data from a DB2 9.7 UDB running on Linux to an Oracle 10g database also running on Linux using the migration capabilities provided by Oracle SQL Developer.

I have used SQL Developer 2.1.1.64.45 which I think is the latest version available for download. I tested moving a 2 million row table which took about 50 minutes.

Have a look at this note which shows all the steps taken for the operation including step by step screenshots.

Appreciate your feedback and kindlly share your experiences in such heterogenous data load exercises with the rest of the community.

Download the note …

Please follow and like us:

Last Update: October 14, 2010  

October 14, 2010 298 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, , ,

7 thoughts on “Migrating data from DB2 to Oracle using SQL Developer

  1. Vineesh S

    Excellent. Although I did not try it practically..the document clearly explains in lay man’s language.

    Thanks Guru…Hats off to u 🙂

  2. Raghav

    While migrating tables from DB2 (ver 8.2) to Oracle (11g) using SQL Developer, I am facing two issues –

    1. Table Data is migrating correctly from DB2 to Oracle with Constraints Non Null, PK, Check; except Referential Integrity (Foreign Key). Row counts are matching in both DB2 and Oracle tables. Only issue is in Foreign Key.

    2. Tables having column default value as CURRENT TIMESTAMP in DB2 are not getting migrated, since Oracle takes SYSDATE instead of CURRENT TIMESTAMP.

    Is there any setting or Configuration to be made for above two in SQL Developer. Can anyone help me?

    Thanks in Advance …

  3. Suman

    Hi,
    When I try to connect to a new connection I dont see DB2 tab(only I see Oracle and access tabs).Please let me know any extra steps need to be done to view the DB2 tab?
    Appreciate if you can give me the details ASAP.

    Thanks&Regards,
    Suman Kedarisetty

  4. Sid

    Hi Gavin

    Excellent doc but can you please let us know how do we get quick migrate option in DB2 m getting copy to Oracle ..is it anything to do with sql developer versiion

    Thanks
    Sid

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?