Обсуждение: 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. > > >