Re: Data transfer between Oracle and Informix

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 2000/04/10
Message-ID: <8ctr6f$iif$1@garnet.tc.umn.edu>#1/1

Depends how much data moves between instances, and what type of schedule. For a one time load or regular interface, a few KB or TB?

There is the Informix 'unload' utility and the onload parallel loader. Oracle has the sqlload utility. These methods are ascii file based, for a quick and dirty solution. To get data out of Oracle there are sqlplus scripts that simulate the Informix 'unload' utility.

Otherwise, depending on you massive budget there are other solutions.

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


---------------------------------------------------------

Received on Mon Apr 10 2000 - 00:00:00 CDT