Re: Migration from INGRESS to Oracle

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 26 Feb 2002 21:09:07 GMT
Message-ID: <3C7BF973.D8AAB2B1@ci.seattle.wa.us>

You can either dump it out as ASCII files and import it using SQL*Loader or purchase the transparent gateway product from Oracle and interface the systems.

What bothers me is that you don't appear to know Oracle well enough to know this ... which makes it easy to conclude that you likely don't understand Oracle well enough to do it well. If that is the case get someone that is a very experienced Oracle Development DBA to act as a consultant on the project.

Daniel Morgan

Totx wrote:

> Hello.
>
> Our customer has an Ingress database. Now, we have to turn it into a Oracle
> database.
> How can we get the data?. We haven't conection to his database and we've
> just Oracle Databases.
> I suposse that he must generate a plain text file with each ingress table's
> data.
> How can he do it?.
> And, to get the definiton of his ingress tables and the constraints and
> indexes, what can we do? (or what must he do to generate that definitio for
> us?.
>
> All your comments will be welcomed!
Received on Tue Feb 26 2002 - 15:09:07 CST