Re: Informix -> Oracle

Depending on the nature of, and how much data you want to transfer and when (one time, or on an ongoing basis), you might also want to look at OmniCopy and OmniReplicator from Praxis ( http://www.praxisint.com ). OmniLoader which the note below mentions is a bulk extract/load facility. OmniCopy does networked & automated snapshot copies. It can be initiated for one-time use, or scheduled to automatically run periodically. OmniReplicator does changed data replication. Data can be replicated continuously (near real-time) or on a scheduled basis. OmniLoader, OmniCopy, and OmniReplicator all handle differing data types, differing table and row names, vertical and horizontal partitioning (row and column selection) and, optionally, data enhancement. Herve Delattre wrote: > > Take a look at Praxis International OmniLoader > (http://www.praxisint.com). > > It's unload the data, do the datatype conversion and use RDBMS native > tools to load the data. > > Regards > > Herve > > "Frank" <xu.frank.f@bhp.com.au> wrote: > > >I am trying to find out what's the best way to transfer data from Informix > >to Oracle. Is there ODBC drivers/tools as such to do that, or just > >extracting data from Informix to a flat file, then load it into Oracle > >tables? > > > >Any suggestions appreciated! > > > >-- > >Frank Xu > >Perth, Australia > >mailto: xu.frank.f@bhp.com.au > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > ^ > ^ Herve Delattre > ^ > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ -- Joel Klebanoff Klebanoff Associates, Inc. Toronto, Canada Phone: (416) 924-6510 Fax: (416) 924-8185