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

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