Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2009
    Posts
    36

    Unanswered: Data Migration from Oracle Tables to DB2 Tables



    Hi All,
    I have some tables that are in Oracle 9i. I have created new tables in DB2 v 9.1.0.5 fixpack '5'. So, now I need to move/copy the data from the Oracle 9i tables to DB2 tables.
    Can anyone please provide me the steps involved/processed when doing this data migration. Any links related to data migration from oracle to db2 tables material is much appreciated.

    Oracle Version: Oracle 9i

    DB2 Version: 9.1.0.5

    OS version: AIX 5.3


    Thanks

  2. #2
    Join Date
    Jul 2008
    Posts
    94
    Option 1
    1.export in to a flat file from Oracle database.
    2.Import or load from flat file to the DB2 Database

    Option 2:

    Data warehouse tool to load the data from hierarchical databases

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    with federation = easy to setup
    have a look at infocenter
    http://publib.boulder.ibm.com/infoce...v9r5/index.jsp
    and search for oracle federation
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by przytula_guy
    with federation = easy to setup
    Agree, but extra licences are required. Just to convert I would unload the oracle tables into flat files and then load the data in db2.
    I'm not familiar with orcale but an equivalent to "db2look" might be handy to convert the DDL.

  5. #5
    Join Date
    Mar 2009
    Posts
    36
    Thanks guyzz for your replies..

    The tablenames and columns names are different both in Oracle and Db2. So I have to map the data and then migrate..

    So, any suggestions on this how to do?

    Thanks All ..I appreciate..

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    have you considered using Migration Toolkit (MTK):
    IBM Migration Toolkit - IBM Information Management

  7. #7
    Join Date
    Aug 2004
    Posts
    18
    There is a pdf document "What to know when transfer Oracle data to DB2 with FastReader" which might be helpful http://www.wisdomforce.com/dweb/reso..._migration.pdf

    Quote Originally Posted by db2pro

    Hi All,
    I have some tables that are in Oracle 9i. I have created new tables in DB2 v 9.1.0.5 fixpack '5'. So, now I need to move/copy the data from the Oracle 9i tables to DB2 tables.
    Can anyone please provide me the steps involved/processed when doing this data migration. Any links related to data migration from oracle to db2 tables material is much appreciated.

    Oracle Version: Oracle 9i

    DB2 Version: 9.1.0.5

    OS version: AIX 5.3


    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •