Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2014
    Location
    India
    Posts
    18

    Unanswered: Data migration from Oracle to DB2

    Hi All,

    Has anyone worked on data migration from an Oracle to DB2 database.

    I need to migrate application data from Oracle(11g) to DB2(10.1) on Linux. Source and target DB schema are pre designed.

    I am looking for the best possible approach.

    I have previously worked on data migration from Oracle to MySQl on windows but have used third party ETL tool.

    Any help will be appreciated.

    Thanks.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Yes I have done oracle to db2 migrations in the past.
    These days (with db2 v10.1 and higher) IBM made it a lot easier, check the Knowledge Centre about the features that get enabled via the DB2_COMPATIBILITY_VECTOR
    Your mileage will vary according to exactly which Oracle features the database uses.
    it's all about the detailed planning...

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by SBA View Post
    I am looking for the best possible approach.
    "Best" according to what criteria?

    There is IBM Database Conversion Workbench that can automate data movement. It will work best if your target schema is exactly the same (table names, data types etc.) as the source, otherwise you'll have to edit the generated load script accordingly.

    If you are already familiar with an ETL tool that supports both data sources it's also an option, obviously.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Feb 2014
    Location
    India
    Posts
    18
    Thanks for your replies.

    Best in terms of - correctness, speed, easier implementation, minimum issues

    Minor differences are possible in table structure of source and target.
    Data types also might not be same as we have different data types in DB2 & Oracle.

Posting Permissions

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