Re: informix to postgres tools?

On Vie 09 May 2003 00:27, Brian Maguire wrote:
> Does anyone know of any Informix to Postgres migration tools?  If not
> maybe more simply words of wisdom...

Database migration?
All that I could find was this:

=========== BEGIN ==================
#!/bin/bash
if test $# -ne 2
then echo "usage: sqlparser <File> <Table>"
exit;
fi
echo "COPY "$2" FROM stdin;" >$1.pg
cat $1|sed ''s/|$//'' | sed ''s/,/\./g''
|sed -e ''s/|/      /g'' >>$1.pg
echo "\." >>$1.pg
echo ""
echo "Transform Complete to upload run cat $1.pg |psql <SERVER>"
echo ""
=========== END ====================

You do a dbexport with Informix, which gives you a directory with files
that contain the data of the diferent tables. This files have to be
runned with this script.

As you see this doesn't do much, even more, I can't say that it wirks,
just because I haven't tried it yet.

Also, you'll have to touch the strcture of the dtabse a bit, because some
types are diferente (or at least written different), like timestamps.

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------