From: Jonah H. Harris <jonah.harris@gmail.com>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Cc: pgsql general <pgsql-general@postgresql.org>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: [SQL] PostgreSQL to Oracle
Date: Fri, 9 Mar 2007 13:32:20 -0500
Message-ID: <36e682920703091032u22cd9901w6212c9aba999ec8c@mail.gmail.com> (raw)
In-Reply-To: <55c095e90703090954m74e2b06arf73e3037f25f5c18@mail.gmail.com>
References: <55c095e90703090954m74e2b06arf73e3037f25f5c18@mail.gmail.com>
On 3/9/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> Is it a simple action to convert a database from PostgreSQL to Oracle ?
Yes, relatively.
> Has someone any idea ?
There's a couple ways to do this, but I'd recommend first using
pg_dump to export schema only.
Your functions and triggers would need to be rewritten, but assuming
they're in PL/pgSQL, it's a fairly trivial task to translate them into
PL/SQL.
As far as the views and sequences are concerned, pull them out of the
pg_dump export and re-run them in TOAD, SQL*Plus, or your favorite
tool.
As far as the type goes, I'm not quite sure what you're doing with it
or how it's used, but it should also be easy to migrate.
To copy the data and table definitions, I'd use a database link (on
the Oracle side) with hsodbc connecting to your PostgreSQL system via
ODBC.
Now that my advice is done with, could you explain why you need to
move to Oracle from PostgreSQL?
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jonah.harris@gmail.com, ezequias.rocha@gmail.com, pgsql-general@postgresql.org
Subject: Re: [SQL] PostgreSQL to Oracle
In-Reply-To: <36e682920703091032u22cd9901w6212c9aba999ec8c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox