Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread Andrew Sullivan
On Thu, Jul 07, 2011 at 12:01:56PM -0400, akp geek wrote: > Thank you all for the responses. All we have is just table migrations, no > procedures, triggers involved. I will try to do the migration using ora2pg. > I downloaded it, while installing it I am getting an error. Will try to > resolve tha

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread akp geek
Craig Ringer > > Subject: Re: [GENERAL] Oracle to Postgres migration open source tool > To: "akp geek" > Cc: "pgsql-general" > Date: Thursday, July 7, 2011, 2:02 PM > > On 7/07/2011 9:55 PM, akp geek wrote: > > Hi all - > > > >

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread Lennin Caro
--- On Thu, 7/7/11, Craig Ringer wrote: From: Craig Ringer Subject: Re: [GENERAL] Oracle to Postgres migration open source tool To: "akp geek" Cc: "pgsql-general" Date: Thursday, July 7, 2011, 2:02 PM On 7/07/2011 9:55 PM, akp geek wrote: > Hi all - > >     

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread Jacqui Caren-home
On 07/07/2011 15:21, salah jubeh wrote: > > Hello, > > I do no have any experience with oracle, try to dump the oracle database in plain format and then try to execute the DDL and DML statements. It might be cumbersome to fix all the errors you might get. > But as an initial solution give it a s

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread salah jubeh
From: casp To: pgsql-general@postgresql.org Cc: cesulba...@gmail.com Sent: Thu, July 7, 2011 4:05:32 PM Subject: Re: [GENERAL] Oracle to Postgres migration open source tool Good truth migration between Oracle and PostgreSQL are not things difficult: Indicates that your database has

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread Andrew Sullivan
On Thu, Jul 07, 2011 at 09:55:45AM -0400, akp geek wrote: > Hi all - > >Are there any open source tools available for migrating from > oracle to postgres. We have 20 tables in oracles that we needed to get to > postgres. Appreciate your help I have used ora2pg. It was not seamles

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread casp
Good truth migration between Oracle and PostgreSQL are not things difficult: Indicates that your database has: Tables: 20 Shema:? functions:? Views:? They need help to migrate ... Or what are you suggestions if you need a tool that already does this task for you good people have a tool interprise

Re: [GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread Craig Ringer
On 7/07/2011 9:55 PM, akp geek wrote: Hi all - Are there any open source tools available for migrating from oracle to postgres. We have 20 tables in oracles that we needed to get to postgres. Appreciate your help One avenue you may wish to investigate is ETL tools like Talend.

[GENERAL] Oracle to Postgres migration open source tool

2011-07-07 Thread akp geek
Hi all - Are there any open source tools available for migrating from oracle to postgres. We have 20 tables in oracles that we needed to get to postgres. Appreciate your help Regards