	AllExperts > Ingres
	Search

About Jean-Pierre Zuate
Expertise
Any questions about database Ingres (owned by Computer Associates then Ingres Corp) : - Ingres 6.4 - OpenINGRES from 1.0 to 2.0 - IngresII from 2.0 to 2.6 - Ingres R3, Ingres 2006 (Open Source version) - All tool around Ingres : ABF, Report Writer, Replicator, OpenROAD (3.5 to 2006), Ingres/NET Ingres/STAR, ...

Experience
16 years of computing experience as :
- AS400 programmer
- AIX / Ingres administrator and developer (OpenROAD and korn shell)
- Ingres DataBase Administrator
- Ingres expert - Data modelisation - ETL - Reporting - Many of Computer Associates sofwares - ITIL / CMDB / Change Management

Organizations
http://lafageconseil.fr

You are here: Experts > Computing/Technology > Databases > Ingres > How to extract data from Ingres DB to Oracle DB

Ingres - How to extract data from Ingres DB to Oracle DB

Expert: Jean-Pierre Zuate - 12/19/2005

Question
Dear jean
I dont know much about ingres, but i would like to tranfer the entire data in ingres to Oracle.
If you dont mine please send me the reply to my query

Answer
Hello,

First sorry to be so late, but I just recover some lost mail access.

Well I really don't know how you can transfer data from ingres to oracle. Does Oracle Corp have something to say about it ? As far as I know, the major problem is you have to take a particular care of date format and money format.

Try to unload your Ingres data in ASCII mode and try a correct reload command in Oracle.

You can also use some ETL to do this job for you. Have a look in Transforce (search transforge into google) if some can be used in a gnu flavour.

Extra question : why do you left Ingres ?

Hope this help,
Jean-Pierre ZUATE

Add to this Answer Ask a Question