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