Transferring Data From An Oracle Database to an Informix

maccten2000 · Aug 16, 2007

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 · Aug 16, 2007

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Transferring Data From An Oracle Database to an Informix

maccten2000

Programmer

olded

Programmer

Similar threads

Part and Inventory Search

Sponsor