Re: Migration from Oracle 11g to Postgresql

Yes, You can use the mentioned method by using scripts or also there are
few migration tools available to perform the migration of schema..

**
*Thanks & Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant & Architect*
*Email:prashant(dot)ranjalkar(at)gmail(dot)com*
*Skype:prashanth.ranjalkar*
*www.postgresdba.net*

On Thu, May 2, 2013 at 7:27 PM, Silvana Bravo <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.
>
>