Re: Informix -> Oracle

"Frank" <xu.frank.f@bhp.com.au> writes: >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? If it's a one time migration, you can write out ASCII data, then pretty easily transform the Informix table definitions into Oracle SQL*Loader control files, and use those to load the tables into Oracle. If you're going to be keeping the data in Oracle and Informix simultaneously and need to keep it all in sync, look into Praxis. -- Cos (Ofer Inbar) -- cos@leftbank.com cos@cs.brandeis.edu -- The Left Bank Operation -- lbo@leftbank.com http://www.leftbank.com/ "Good literature is about Love and War." "Junk fiction is about Sex and Violence."