I need to export several data files/tables from Ingres II 2.1 on an HP UX system to an IBM iSeries DB2 platform. I can do this with a SQL tool that exists on the Ingres machine, but all that creates are flat files. I want to maintain the field names, definitions, etc. as well as the data. Are you aware of any tools or methods to do this?
Some of the case tools allow you to "reverse engineer" your database and generate a schema script, if you can find one that works with both Ingres and DB2 you may be able to do it that way.
If you're willing to do some hand work you could run "copydb" in Ingres, which would generate an unload script (copy.out) and a reload script (copy.in). The reload script will contain all the SQL (in Ingres format) needed to re-create the entire schema; with some massaging you may be able to convert the copy.in script into DB2 format.
Login
Register
Ingres.com
Export Ingres data to iSeries DB2
Linear Mode
