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
-----------------------------------------------------------------