Re: Oracle to PostgreSQL - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Oracle to PostgreSQL
Date
Msg-id Pine.LNX.4.33.0308060942060.15751-100000@css120.ihs.com
Whole thread Raw
In response to Oracle to PostgreSQL  ("Marco Roda" <MarcoRoda@amdosoft.com>)
List pgsql-admin
On Wed, 6 Aug 2003, Marco Roda wrote:

> Hi,
>
> I need to port data from an Oracle 8.0 base to PostgreSQL 7.2.
> I have scripts to create the base on Oracle and PostgreSQL (it is about 40
> tables), but I need to port a great amount of data to PostgreSQL.
> Can anybody help me?

There's a script in the contrib directory called something like ora2pg
that's been helpful to some folks.

EMS makes a migration program http://www.ems-hitech.com/pgsqlutils that
might help too.  Haven't used it, but it's only $39 and I think they have
trial versions available.


pgsql-admin by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Postgresql slow on XEON 2.4ghz/1gb ram
Next
From: "Arthur Ward"
Date:
Subject: Re: syslog enabled causes random hangs?