How to move from Postgres95 to Informix?

Posted in 1996

Peter Benjamin — Sat, 14 Sep 1996 19:15:04 -0700 — source: Informix-list mailing list archive (1991-1998)

I have been tasked with translating a PostGres95 database to Informix Online. I heard rumour of a conversion tool already done. Do you know of it or any lead to it? Otherwise, I could use your advise on what approach you would take to migrate the data. Postgres95 runs on a Sparc 20 and Informix Online will be on Windows NT. Both are on the web. Here are three options I have thought of: Moving the Postgres95 binary data files to WindowsNT and parsing with just enough ported Postgres95 source code to load the Informix Online database via ODBC or SQL seems the best. ODBC or SQL calls from one to the other might be possible over NFS mounting or other protocol. Converting the Postgres95 tables (about 5) to an ascii format dump and FTPing to the Windows NT box and running the data back into Informix seems brute force, doing and a fall back solution. Thanks, Pete