Thread: Migrating data from Oracle 9i to PostgreSQL
Hi :-) I sure hope I'm asking in the right place... Is there any automated or semi-automated way of migrating data from Oracle database (9.2.0.4) to PostgreSQL one? I only need the data, nothing else (not stored procedures, indexes, etc.), the relations are pretty simple, for example: CREATE TABLE EMAIL ( UNID VARCHAR2(32 BYTE) NOT NULL, SUBJECT VARCHAR2(4000 BYTE), SEND_FROM VARCHAR2(255 BYTE), PRODUCT_CASE_ID VARCHAR2(32 BYTE), RECEIVE_DATE DATE, SEND_TO VARCHAR2(255 BYTE), SUBMITED_BY VARCHAR2(255 BYTE), COPY_TO VARCHAR2(255 BYTE), SEND_BY VARCHAR2(255 BYTE), PUB INTEGER DEFAULT 0 NOT NULL, CONTENT CLOB DEFAULT empty_clob(), RECIPIENT VARCHAR2(255 BYTE) ) I will be very grateful for any suggestions. Best regards, Maciej Zieba
am 04.04.2006, um 14:01:30 +0200 mailte krokodylek@tenbit.pl folgendes: > > Hi :-) > > I sure hope I'm asking in the right place... > > Is there any automated or semi-automated way of migrating data from Oracle > database (9.2.0.4) to PostgreSQL one? http://techdocs.postgresql.org/#convertfrom HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
Hi, On Tuesday 04 April 2006 14:01, krokodylek@tenbit.pl wrote: | I sure hope I'm asking in the right place... | | Is there any automated or semi-automated way of migrating data from Oracle | database (9.2.0.4) to PostgreSQL one? | | I only need the data, nothing else (not stored procedures, indexes, etc.), | the relations are pretty simple, for example: you might want to look at the scripts from the contrib/oracle directory from the PostgreSQL source distribution. It did help me a lot to migrate two databases from Oracle to PostgreSQL. It might be useful to apply the attached patch: it escapes some more characters in the generated SQL dump. Ciao, Thomas -- Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----