Home > IT Answers > Database > Advice needed to move from DB2/400 flat-file system to Oracle
DebraTart
0 pts.
 Advice needed to move from DB2/400 flat-file system to Oracle
DB2 Universal Database
Koteswararao wrote in with this question recently: "We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the metamodel(total DDL scripts) from DB2/400 and go to datamodeling. Initially I thought Oracle Migration Workbench (OMWB). Unfortunately, it is not supported by V5R4 of DB2/400 on the iSeries. So I can?t use OMWB. Erwin Data modeler is unable to extract the relations directly from database." Do you know what approach he should take? -- Debra Tart, associate editor, Search400.com

Software/Hardware used:
ASKED: December 21, 2005  9:59 AM
UPDATED: December 23, 2005  2:31 AM
RELATED QUESTIONS
Answer Wiki:
Try Visio. One of the advanced versions (I don't remember ms's naming convention) can reverse engineer a db. The iSeries as a DB2 instance is supported, and the ERD's Visio generates are usable. You should be able to have visio traverse a schema and build the ERD, then export the DDL to Oracle.
Last Wiki Answer Submitted:  December 22, 2005  8:24 am  by  Pcatlin   200 pts.
All Answer Wiki Contributors:  Pcatlin   200 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Try iSeries Navigator. You can create a DDL from any library.

Best regards

Fernando Martinez

Fernan
 0 pts.