Re: Informix data to Oracle

From: Emmon Simbo <esimbo_at_openlinksw.co.uk>
Date: Thu, 13 May 1999 10:23:11 +0100
Message-ID: <373a95b0.0@nnrp1.news.uk.psi.net>

Hi Neil

You might want to try Openlink Virtuoso. This will allow you to connect to both your Oracle and Informix databases via ODBC, UDBC, OLE/DB etc. When you have linked both tables, you could then transfer from one to the other.

Just an idea as ODBC might be your best bet here if you can't get it working with Oracle.

HTH Best Regards

Neil Truby <ntruby_at_netcomuk.co.uk> wrote in message news:7hci08$df6$1_at_taliesin.netcom.net.uk...
> Does anyone have any experience of moving a large-ish (~10GBytes) database
> from an Informix to Oracle server?
>
> I'm wondering if there's something you can do with the output from the
> Informix dbexport utility, which produces a datbase schema and an ASCII
> unload of each table in pipe-delimited format, and Oracle's SQL *Loader.
>
> Any hints and tips would be gratefully received.
>
> Neil (ntruby_at_netcomuk.co.uk)
>
>
Received on Thu May 13 1999 - 04:23:11 CDT