Ingres dump files to PostgreSQL
Hi
I have a dump from an Ingres database, one file per table it seems. I went
looking on www.postgresql.org for documentation for people who want to move
to PostgreSQL from other databases, but I couldn't find any such thing.
So, does a convert utility from ingres dump files to PostgreSQL already exist?
It's not a big problem for me; I can write a perl program to do the stuff. i
just started wondering about it, giving their common ancestry.
On K, 2005-05-18 at 12:57 +0200, Kaare Rasmussen wrote:
Hi
I have a dump from an Ingres database, one file per table it seems. I went
looking on www.postgresql.org for documentation for people who want to move
to PostgreSQL from other databases, but I couldn't find any such thing.So, does a convert utility from ingres dump files to PostgreSQL already exist?
It's not a big problem for me; I can write a perl program to do the stuff. i
just started wondering about it, giving their common ancestry.
The common ancestry is form times when Ingres (University Ingres) used
Quel for its query language, before time when Postgres (without "ql" at
the end) was created, which used PostQuel up to v4.2 .
There are migration scripts for Oracle and MySQL in contrib.
--
Hannu Krosing <hannu@skype.net>
Kaare,
I have a utility which will read Ingres r3 data files directly but I
don't think it would be that reliable to use. I suggest you get one of
the open source database conversion utilities written in Java, they work
pretty well. You can find a few of them on SourceForge/Freshmeat.
Thanks!
-Jonah
Hannu Krosing wrote:
Show quoted text
On K, 2005-05-18 at 12:57 +0200, Kaare Rasmussen wrote:
Hi
I have a dump from an Ingres database, one file per table it seems. I went
looking on www.postgresql.org for documentation for people who want to move
to PostgreSQL from other databases, but I couldn't find any such thing.So, does a convert utility from ingres dump files to PostgreSQL already exist?
It's not a big problem for me; I can write a perl program to do the stuff. i
just started wondering about it, giving their common ancestry.The common ancestry is form times when Ingres (University Ingres) used
Quel for its query language, before time when Postgres (without "ql" at
the end) was created, which used PostQuel up to v4.2 .There are migration scripts for Oracle and MySQL in contrib.