Re: Migrate to Oracle from Informix

There are tool: Don't use them. The underlying architecture for transactions, etc. is different. Informix logic in an Oracle database will create data integrity issues and a lack of scalability.

First step is to get Tom Kyte's book "expert one-on-one Oracle" and read the first three chapters ... paying special attention to multiversioning, locking, and transactions (then finish the book). Port the tables using some tool like ERwin if you don't have the DDL but you really should do a rewrite of the code.

You have been handed a peach ... eat it. Better a resume that says Oracle than a resume that says Informix.

Daniel Morgan

YW wrote:

> Hi,
> Any one has experience in migrating to Oracle from Informix? Are
> there any tools available, especially in the area of converting the
> 4gl app? Thanks.
> Y.Wei
Received on Fri Mar 22 2002 - 18:31:18 CET