Topic
  • 2 replies
  • Latest Post - ‏2012-11-19T18:53:31Z by dtc
openeis
openeis
6 Posts

Pinned topic How to migrate data model from oracle to db2

‏2012-11-18T02:08:32Z |
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
    null
    60 Posts

    Re: How to migrate data model from oracle to db2

    ‏2012-11-19T16:45:40Z  
    IDA doesn't provide database migration. IBM has a product "IBM Migration Toolkit" which supports migrations from source databases to target database.

    Thanks,
    -April
  • dtc
    dtc
    63 Posts

    Re: How to migrate data model from oracle to db2

    ‏2012-11-19T18:53:31Z  
    To 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>
    </Bridge>
    You can select any supported DB2 version as the Target database.