Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Vibhor Kumar
On May 2, 2013, at 10:38 AM, "McKinzie, Alan (Alan)" wrote: > 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. Ora2Pg is a good tool for one time migration. However, when we come to crucial p

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread McKinzie, Alan (Alan)
:30 AM To: pgsql-admin@postgresql.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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Simpson, John (IMS)
I used Ora2Pg to migrate our production databases from Oracle 10g to Postgres a couple years ago. It was extremely simple. http://ora2pg.darold.net/ From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Silvana Bravo Sent: Thursday, May 02, 2013 9:58 AM T

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Paul B. Anderson
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, Vib

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Leonardo Carneiro
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 wrote: > > On May 2, 2013, at 9:57 AM, Silvana Bravo wrote: > > > Hello, I'm planning a migration of production DBs from Orac

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Vibhor Kumar
On May 2, 2013, at 9:57 AM, Silvana Bravo 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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Prashanth Ranjalkar
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.p

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Igor Neyman
From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Silvana Bravo Sent: Thursday, May 02, 2013 9:58 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Migration from Oracle 11g to Postgresql Hello, I'm planning a migration of production DBs from Oracle