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

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 31 Jan 2007 15:30:25 -0800
Message-ID: <1170286225.647290.83040@v33g2000cwv.googlegroups.com>

Jack wrote:
> 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.

If your schema will stay the same then of course migration workbench or a similar tool will be your primary tool. If you need to make data conversion to different schema manually then you can check my paper "Data migration from old to new application: an experience" at http:// www.gplivna.eu/papers/legacy_app_migration.htm

Gints Plivna
http://www.gplivna.eu Received on Wed Jan 31 2007 - 17:30:25 CST