Ingres dump files to PostgreSQL

Started by Kaare Rasmussenover 20 years ago3 messages
#1Kaare Rasmussen
kar@kakidata.dk

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.

#2Hannu Krosing
hannu@skype.net
In reply to: Kaare Rasmussen (#1)
Re: Ingres dump files to PostgreSQL

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>

#3Jonah H. Harris
jharris@tvi.edu
In reply to: Hannu Krosing (#2)
Re: Ingres dump files to PostgreSQL

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.