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.
This topic has been locked.
3 replies Latest Post - 2007-05-08T09:04:41Z by SystemAdmin
Pinned topic DB2 to Oracle Runtime Database Migration
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2007-05-08T09:04:41Z at 2007-05-08T09:04:41Z by SystemAdmin
Re: DB2 to Oracle Runtime Database Migration2007-05-07T08:42:27Z in response to SystemAdminBrian,
we recently had a customer who made this approach.
However they eventually gave up and did a 'manual' migration of their
The risk to produce invalid data was too high.
There is no 1:1 mapping of DB2 to Oracle content because of the internal
between the products of the two database vendors.
My recommendation is, to write a tool for a 'manual' migration of your
data to Oracle.
IBM WebSphere Process Server Development