	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 > Convert Ingres data to DB2

Ingres - Convert Ingres data to DB2

Expert: Jean-Pierre Zuate - 11/20/2008

Question
We are migrating from an HP UX system with Ingres 2.1 database to an iSeries with DB2. We need to migrate all of our data to DB2, and we would like to maintain the field names, attributes, etc. in the process. Can you offer some steps and/or tools that can do this? I have very little Ingres or Unix experience. Thanks.

Answer
Hello,

To migrate data from an ingres installation to an other or from ingres to something else you can use one of those tools :
- copydb
- unloaddb

copydb can work with one table (or a list) and unloaddb work with all DB objects (include some Ingres application like openroad, abf, report writer, etc).

Both of these command work on the same way :
1/ run "unloaddb" or "copydb" to generate SQL
2/ run the SQL to extract the data

Studdy the -c option to have an ASCII extract (rather than a binary one).

Please see help on those commands here :
- copydb : http://docs.ingres.com/cmdref/copydbCommandCopyandRestoreaDatabase
- unloaddb : http://docs.ingres.com/cmdref/unloaddbCommandCreateCommandFilesforUnloadingandRe...

Hope this help you,

Regards,
Jean-Pierre ZUATE
http://lafageconseil.fr

Add to this Answer Ask a Question