| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Move From Oracle DB to PostgreSQL DB |
| Date: | 2011-03-14 19:37:00 |
| Message-ID: | 20110314193700.GB63903@shinkuro.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Mar 14, 2011 at 02:43:17PM -0400, gene(dot)poole(at)macys(dot)com wrote:
> Is there a recent tutorial, white paper, how to on move/migrate from
> Oracle to PostgreSQL? I can get the Oracle schema DDL by pointing our
> Data Modeling software at the Red Hat Satellite server and extracting the
> DDL. It will take that Oracle DDL and convert it to PostgreSQL, but only
> version 8.x, and we were planning on looking at the open source PostgreSQL
> 8. Are the differences between versions that great?
Not really, no. You might also have a look at ora2pg. I have used
it, and while it still has some sharp corners it works.
A
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2011-03-14 19:37:17 | Re: Move From Oracle DB to PostgreSQL DB |
| Previous Message | Devrim GÜNDÜZ | 2011-03-14 19:33:22 | Re: Move From Oracle DB to PostgreSQL DB |