OMWB

[Andy Kent]

If you search for Oracle Migration Workbench (OMWB) from oracle.com
you only seem to get broken and dead-end links.

Has anyone any idea where this product is at at the moment?

Has anyone got any stories to relate of using it?

Thanks

Andy Kent

[Mark Townsend]

Re: OMWB

Andy Kent wrote:

If you search for Oracle Migration Workbench (OMWB) from oracle.com
you only seem to get broken and dead-end links.
>
Has anyone any idea where this product is at at the moment?
>
Has anyone got any stories to relate of using it?
>
Thanks
>
Andy Kent

http://otn.oracle.com/tech/migration/index.html

[Frank]

Re: OMWB

Andy Kent wrote:

If you search for Oracle Migration Workbench (OMWB) from oracle.com
you only seem to get broken and dead-end links.
>
Has anyone any idea where this product is at at the moment?
>
Has anyone got any stories to relate of using it?
>
Thanks
>
Andy Kent

It's on the download page of otn.oracle.com.

As for it's usage, the current production version has
some limitations:
- does not support generation of more than 512 tables
- does not support 9i ANSI syntax, and cannot correctly
create all outer joins (for which OMWB itself warns)
- has difficulties reading SQL Server 2000 online; works
OK when using the Disconnected Capture.
- Works OK with Access (usually smaller in number of objects,
limits don't get reached, probably
- Is inconsistent in usage of upper and lowercase object naming,
and usage of double quotes - resuling in malformed statements.

I'd suggest you simply try it, and see if you like it, and
can live with the limitations. I updated the internal repository
to get passed some of them (upper case...)
--
Regards, Frank van Bortel