Move From Oracle DB to PostgreSQL DB

Поиск
Список
Период
Сортировка
От gene.poole@macys.com
Тема Move From Oracle DB to PostgreSQL DB
Дата
Msg-id OFAAF039B8.FD4F11D9-ON85257853.0065D7CE-85257853.0066D72C@MACYS.com
обсуждение исходный текст
Ответы Re: Move From Oracle DB to PostgreSQL DB  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Re: Move From Oracle DB to PostgreSQL DB  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Move From Oracle DB to PostgreSQL DB  (Stephen Frost <sfrost@snowman.net>)
Re: Move From Oracle DB to PostgreSQL DB  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Just a little background:

We're running Red Hat Satellite Server and it's used to provision our servers (both physical and virtual).  It works great and we have no issues with it  *except* It will only provision Red Hat.

Why this question:

We've been directed by our management to examine the use of other Linux distributions, like SUSE and Oracle Enterprise Linux.

The 'real' questions:

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?

Any information or help would be appreciated.

Thanks,
Gene Poole

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Re: DBMS upgrade and backups
Следующее
От: Stefan Gündhör
Дата:
Сообщение: Create a view with variable amount of columns depending on the rows of a table