You are here:

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

Advertisement

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

Ingres

All Answers

Answers by Expert:

Ask Experts

Volunteer

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) - Ingres 9.x, Ingres 10.x - 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

Education/Credentials
Computing bachelor (1989)

Past/Present Clients
More than 100 customers during my 6 years of CA has an Ingres consultant, all around France and Africa (Togo, Cameroon, Morrocco, ...)

©2012 About.com, a part of The New York Times Company. All rights reserved.