Re: Migrating from Ingres to Oracle

"Michael Martin" <michael.martin_at_nrm.qld.gov.au> wrote in news:BlHnf.316$Hs.26650_at_news.optus.net.au:

> Has anyone migrated from Ingres to Oracle recently? Where there any
> major issues?
> What about migrating;
> . procedure/rules to PL/SQL
> . data types
> . indexes & key, foreign constraints etc
> . non ANSI SQL
> . embedded SQL/C
> . JDBC, ODBC
> . other third party products (tuxedo etc)
> . any other issues
>
> If you migrated, why did you go from Ingres to Oracle?
>
> Thanks
> Michael
>
>
>

Hi Michael,

we also want to migrate from Ingres to Oracle in the near future so I can't answering the first question. The reason for the plan to migrate to Oracle is that the application on top of Ingres is written in ABF so we still have to use Ingres 6.4 on Solaris 2.6. Our Oracle rep here in Germany offered a nearly 'automatic' transfer from Ingres to Oracle and ABF to [ Forms || Java with Spring framework]. But we are in the really beginning so there is no experience how it works. You should check the Oracle sites.

hth Henner Received on Wed Dec 14 2005 - 12:16:20 CST