Re: Data transfer between Oracle and Informix

Have you considered full blown replication? I assume this is a business process rather than a one-time move of data? Sybase Replication Server will talk to both servers and give you more options for future DB's.

In article <38F3A844.EAD83478_at_auckland.ac.nz>,   Bridget Reitsma <b.reitsma_at_auckland.ac.nz> wrote:
> Hi Hans,
>
> We are currently in the process of moving data from our Informix
 7.30UC5
> platform to Oracle 8.0.5 (all PeopleSoft data). We have used data
 mover to
> move all the data over - this is has proved to be a lenghtly exercise
 and if
> you come up with better ideas of how to do it I'd love to here about
 it -
> otherwise I can give you and overview of what we have done.
>
> cheers bridget
>
> Hans Siebrand wrote:
>
> > I am wondering what tools are availbale to move data between the two
> > databases. I am going to be moving our PeopleSoft database to
 Oracle 8.1.5
> > from Informix 7.22, also moving data from JD Edwards on Oracle
 8.1.5 to out
> > datawarehouse on Informix 7.31
> >
> > Thanks in advance
> > Hans
> >
> > ------------------
> > Hans Siebrand
> > Data Analyst
> > Iluka Resources Limited
> > Ph: +61 8 9780 3215
> > Fax: +61 8 9727 2353
> > Email: hans.siebrand_at_iluka.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 12 2000 - 00:00:00 CDT