Re: Migration from Oracle 11g to Postgresql

I used ora2pg a couple years ago. I made a few minor changes to fit our specific requirements, but it worked well for our migration to Postgresql.

Alan

From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Paul B. Anderson
Sent: Thursday, May 02, 2013 9:30 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Migration from Oracle 11g to Postgresql

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(dot)aim(at)gmail(dot)com<mailto:vibhor(dot)aim(at)gmail(dot)com>> wrote:

On May 2, 2013, at 9:57 AM, Silvana Bravo <bravo(dot)silver(at)gmail(dot)com<mailto:bravo(dot)silver(at)gmail(dot)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.htm#P6096_508028

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com

--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin