Topic
  • 3 replies
  • Latest Post - ‏2007-05-08T09:04:41Z by SystemAdmin
SystemAdmin
SystemAdmin
2340 Posts

Pinned topic DB2 to Oracle Runtime Database Migration

‏2007-05-03T15:46:46Z |
My understanding is that there is currently no automated migration utility for moving from a DB2 to Oracle runtime database, and that a manual migration is not supported by IBM.

However, has anyone had any success in doing a migration "on your own"?

We have a runtime database that has tens of thousands of processes on any given day and would like to move it to Oracle for maintenance reasons (we are an Oracle shop). Starting from a clean database is not a desirable proposition for us.

We attempted a manual migration by creating the Oracle table structure, and exporting/importing the data. However, we could not bring up the servers.

Thanks in advance for your comments.
Updated on 2007-05-08T09:04:41Z at 2007-05-08T09:04:41Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    2340 Posts

    Re: DB2 to Oracle Runtime Database Migration

    ‏2007-05-07T08:42:27Z  
    Brian,

    we recently had a customer who made this approach.
    However they eventually gave up and did a 'manual' migration of their
    data.
    The risk to produce invalid data was too high.

    There is no 1:1 mapping of DB2 to Oracle content because of the internal
    differences
    between the products of the two database vendors.

    My recommendation is, to write a tool for a 'manual' migration of your
    data to Oracle.

    Volker Hoss
    IBM WebSphere Process Server Development
  • SystemAdmin
    SystemAdmin
    2340 Posts

    Re: DB2 to Oracle Runtime Database Migration

    ‏2007-05-07T16:18:46Z  
    Brian,

    we recently had a customer who made this approach.
    However they eventually gave up and did a 'manual' migration of their
    data.
    The risk to produce invalid data was too high.

    There is no 1:1 mapping of DB2 to Oracle content because of the internal
    differences
    between the products of the two database vendors.

    My recommendation is, to write a tool for a 'manual' migration of your
    data to Oracle.

    Volker Hoss
    IBM WebSphere Process Server Development

    Thank you Volker.

    By writing a tool to do a manual migration, do I understand you to mean use the API to re-create, route, and assign the existing processes?
  • SystemAdmin
    SystemAdmin
    2340 Posts

    Re: DB2 to Oracle Runtime Database Migration

    ‏2007-05-08T09:04:41Z  

    Thank you Volker.

    By writing a tool to do a manual migration, do I understand you to mean use the API to re-create, route, and assign the existing processes?
    Brian,

    yes, that is exactly what I meant.

    Volker Hoss
    IBM WebSphere Process Server Development