From: Paul B. Anderson <paul.a@pnlassociates.com>
To: pgsql-admin@postgresql.org
Subject: Re: Migration from Oracle 11g to Postgresql
Date: Thu, 02 May 2013 10:30:23 -0400
Message-ID: <5182787F.1070501@pnlassociates.com> (raw)
In-Reply-To: <CAP5xjbv8tncUfbx7o4ZCtQNa_RyYdOfAhJfFGM+94HZgV9XSWA@mail.gmail.com>
References: <CANwDVowrLpzvgizkz+ene1K21ttX3W_voqTVErt8vyDCnPyU6g@mail.gmail.com>
<C202FD88-E84A-4DB6-99CB-60B89A4AE1B5@gmail.com>
<CAP5xjbv8tncUfbx7o4ZCtQNa_RyYdOfAhJfFGM+94HZgV9XSWA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
There is also ora2pg. I have not tried it but it looks easy.
http://ora2pg.darold.net/
On 5/2/13 10:18 AM, Leonardo Carneiro wrote:
> I used full convert to convert firebird DBs to postgresql. with a few
> tweaks, works like a charm. never tried with oracle.
>
>
> On Thu, May 2, 2013 at 11:09 AM, Vibhor Kumar <vibhor.aim@gmail.com
> <mailto:vibhor.aim@gmail.com>> wrote:
>
>
> On May 2, 2013, at 9:57 AM, Silvana Bravo <bravo.silver@gmail.com
> <mailto:bravo.silver@gmail.com>> wrote:
>
> > Hello, I'm planning a migration of production DBs from Oracle to
> > Postgresql. I would like to receive some suggestions, advising
> or links to
> > related subjects. I decided to rewrite all store procedures,
> that is not a
> > problem. But regarding the data I was thinking in migrating
> schema by
> > schema. First, create all table structures in postgresql schema.
> Then,
> > generate inserts statements from Oracle schema to extract all
> data. Addapt
> > those inserts to the .sql script/s in postgresql schema.
> > I'm currently making a POC of that process since the schemas to
> migrate are
> > not so big. Only a few tables have around 1.000.000 of rows.
> > That would be the manual migration. Are there some other ways to
> make this?
> >
> > Thanks for the support and I'm glad to start with postgres.
>
>
> You can use Migration Tool kit or xDB Replication solution from
> Oracle to PostgreSQL.
> http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51...
>
> Thanks & Regards,
> Vibhor Kumar
> Blogs:http://vibhork.blogspot.com
> http://vibhorkumar.wordpress.com
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
> <mailto:pgsql-admin@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
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-admin@postgresql.org
Cc: paul.a@pnlassociates.com
Subject: Re: Migration from Oracle 11g to Postgresql
In-Reply-To: <5182787F.1070501@pnlassociates.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