converting oracle script to db2 (hr_main.sql)

[z]

Is there a tool for converting oracle scripts
to db2?

In particular I want to convert oracle example
script hr_main.sql to db2.

I imagine it might not be difficult to do by hand,
for this particular case, but an answer to
the general question might be interesting anyway.

Also, if there is no automated tool available,
perhaps I could get a pointer to common hints
on how to do this manually.

Thanks!

[peteh]

Hello z;
Take a look at the IBM Mogration Toolkit at
http://www-306.ibm.com/software/data...X42&S_CMP=MGST
(watch for wrapping url)

It does a decent job of many conversion items, but depending upon the
complexity of your stored procs, you'll still have alot of work to do.
I found the toolkit to be a great jumpstart though and it has come a
long way in the last year.

Pete H

[Eugene F]

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