| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Marco Roda <MarcoRoda(at)amdosoft(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Oracle to PostgreSQL |
| Date: | 2003-08-06 15:45:37 |
| Message-ID: | Pine.LNX.4.33.0308060942060.15751-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arthur Ward | 2003-08-06 17:14:09 | Re: syslog enabled causes random hangs? |
| Previous Message | The Hermit Hacker | 2003-08-06 15:06:47 | Re: Postgresql slow on XEON 2.4ghz/1gb ram |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-08-06 15:51:26 | Re: schemas and system tables |
| Previous Message | Merlin Moncure | 2003-08-06 15:25:50 | schemas and system tables |