I would try using IBM Migration Toolkit (MTK)
http://www-306.ibm.com/software/data/db2/migration/mtk/ where you can
install the schema by hr_main.sql in a Oracle database and then
generate the scripts for DB2 from MTK connected to this Oracle schema.
Another option is to create a federated Oracle-DB2 database and then
use db2look to produce the DDLs from the DB2 schema attached directly
to Oracle. Both approaches are reverse-engineering in essence.
-Eugene
Received on Wed Feb 15 2006 - 16:44:40 CST
