NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2012-11-19T18:53:31Z by dtc
Pinned topic How to migrate data model from oracle to db2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
How to migrate data model from oracle to db2 using IBM InfoSphere Data Architect?
Updated on 2012-11-19T18:53:31Z at 2012-11-19T18:53:31Z by dtc
null 0600011FWD59 Posts
dtc 120000NKV263 PostsACCEPTED ANSWER
Re: How to migrate data model from oracle to db22012-11-19T18:53:31Z in response to openeisTo migrate data model (not data base) from Oracle to DB2, you can use the Data Model Import Wizard. If the data model is an ERwin or PowerDesigner model, for example, the import is enabled by default. If the data model is meant to be the database metadata, you can change the value of enabled to 'True' in the following in the MIRModelBridges.xml file:
<Bridge id='JdbcOracle' enabled='False' windowsOnly='False'>
<DisplayName id='' enabled='True'>Oracle Database (via JDBC)</DisplayName>
You can select any supported DB2 version as the Target database.