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