Re: Migration From Sybase To Oracle - White papers, tools, etc.

Jack schreef:
> A critical bank application will no longer support Sybase and I will
> have to migrate it to Oracle sometime this spring. In the past I have
> migrated an Informix database to Oracle, but it was quite awhile ago.
> The application's uses Sybase 12.5.0.3 and the target server probably
> will be Oracle 9i or 10g. The conversion will require the transfer of
> devices, tables, indexes, constraints, stored procedures, batch jobs,
> etc.
>
> What I need now is to know what resources are available to me. Are
> there any good white papers readliy available? Are there any good
> tools available? I heard that Oracle Migration Workbench has some
> problems. I know nothing on how good SwisSQL is. I would appreciate
> some pointer.
>

Oracle Migration Workbench did the job for me. Plus your fingers - you will need a lot of reworking, especially in the procedure corner.

Data extraction, and basic model (tables, indexes) work like a charm. Referential constraints are likely to be missed (non existent in source?)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...