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.
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:27ZThis is the accepted answer. This is the accepted answer.Brian,
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
Re: DB2 to Oracle Runtime Database Migration2007-05-07T16:18:46ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
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?