Received: from ingenico.com.au (unknown [202.167.40.101]) by postgresql.org (Postfix) with ESMTP id 5BEB84765FC; Thu, 11 Apr 2002 20:32:36 -0400 (EDT) Message-ID: <003601c1e1b9$5bcbd950$660d090a@software.ingenico.com.au> From: "Nicolas Bazin" To: , "PostgreSQL-development" Subject: Informix to PostgreSQL (JDBC) Date: Fri, 12 Apr 2002 10:31:16 +1000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0033_01C1E20D.2D672070" X-Archive-Number: 200204/536 X-Sequence-Number: 21206 This is a multi-part message in MIME format. ------=_NextPart_000_0033_01C1E20D.2D672070 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 p= rivilege are not created even though it is available from the JDBC.=20 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/hsqld= b/util directory you also need the src/org/hsqldb/lib directory. ------=_NextPart_000_0033_01C1E20D.2D672070 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Just to let you know that you can use the = transfer=20 tool of the hsqldb JAVA database to transfer database from Informix to Post= gres.=20 I have used it  to transfer my application from IDS 7.3 to Postgres 7.= 2.1.=20 Because it relies on JDBC, it can be used/expen= ded to=20 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=20 source)
- autoincrement fields
 
As it's  based on JDBC, it cannot ext= ract=20 VIEWs or store procedures. User privilege are not created even though = it is=20 available from the JDBC.
A further extension would then be:<= /DIV>
support of GRANT and also the possibility = to=20 transfer to a specific schema.
 
You can download it at htt= p://prdownloads.sourceforge.net/hsqldb/hsqldb_1_7_0_RC4.zip
The transfer tool is independent of the da= tabase.=20 It's in the src/org/hsqldb/util directory you also need the src/org/hsqldb/= lib=20 directory.
 
------=_NextPart_000_0033_01C1E20D.2D672070--