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.ranjal...@gmail.com* *Skype:prashanth.ranjalkar* *www.postgresdba.net* On Thu, May 2, 2013 at 7:27 PM, Silvana Bravo <bravo.sil...@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. > >
