Thread: Informix to PostgreSQL (JDBC)
Just to let you know that you can use the transfer tool of the hsqldb JAVA database to transfer database from Informix to Postgres. I have used it to transfer my application from IDS 7.3 to Postgres 7.2.1. Because it relies on JDBC, it can be used/expended to support other databases.
It supports:
- tables structure creation,
- default field value,
- index creation (unique or not),
- data transfer,
- foreign keys creation,
- it supports schema (to read the source)
- autoincrement fields
As it's based on JDBC, it cannot extract VIEWs or store procedures. User privilege are not created even though it is available from the JDBC.
A further extension would then be:
support of GRANT and also the possibility to transfer to a specific schema.
You can download it at http://prdownloads.sourceforge.net/hsqldb/hsqldb_1_7_0_RC4.zip
The transfer tool is independent of the database. It's in the src/org/hsqldb/util directory you also need the src/org/hsqldb/lib directory.