Transferring Data From An Oracle Database to an Informix

[maccten2000]

Hi All

We currently have a production live system which contains many tables which i need to roll up into summary tables
This needs to be done so we can build reporting web pages off them and not impact the live database
To do this i was going to use a stored procedure
The procedure was going to create the roll up tables on an informix system and then run a select statement to the oracle system and then insert the selected information into the informix system
Does anyone know if this is possible and of sp could you point me in the right direction

Thanks for your time on this
Macc

 

[olded]

Back in 1995, I needed to move data between different databases. I used something called Data Junction. It's now owned by Pervasive Software. Go to:

http://ww1.pervasive.com/

and click on 'Data Conversion & Migration'.

In those days, I was using window's 3.1, and the product worked successfully. I haven't used the product since so I really have no opinion now.