Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
suhas_bt022
Date:
We are trying to migrate a huge oracle database to postgresql.. I am finally
stuck with conversion of a huge database with around 250 stored procedures
.Its very painful procedure to convert plsql to plpgsql manually..
Anyone worked out a better solution for this ?
Any script or tool might help



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
Dinesh Kumar
Date:
Hi ,

On Thu, Feb 6, 2014 at 12:07 PM, suhas_bt022 <suhas_bt022@yahoo.co.in> wrote:
We are trying to migrate a huge oracle database to postgresql.. I am finally
stuck with conversion of a huge database with around 250 stored procedures
.Its very painful procedure to convert plsql to plpgsql manually..
Anyone worked out a better solution for this ?
Any script or tool might help

I believe, EnterpriseDB's runMTK tool kit helps you on this. Otherwise, you can try with this.

Thanks,
Dinesh



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
suhas_bt022
Date:
Hi,

Ora2pg does not translate PL/SQL into Postgresql PL/pgSQL.
We need to do it manually.
I was looking for a open source solution to this problem .

Thanks
Suhas



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797p5790832.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
Dinesh Kumar
Date:
Hi Suhas,

On Thu, Feb 6, 2014 at 6:02 PM, suhas_bt022 <suhas_bt022@yahoo.co.in> wrote:
Hi,

Ora2pg does not translate PL/SQL into Postgresql PL/pgSQL.
We need to do it manually.
I was looking for a open source solution to this problem .


Ora2Pg do converts the PL/SQL objects to PL/PGSQL. I haven't tried it , but from their website, it seems it supports this functionality.

Find this here.
-p | --plsql      : Enable PLSQL to PLPSQL code conversion.
If this is not you are looking for, then hope some will give you another open source tool.
 
Thanks,
Dinesh

Thanks
Suhas



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797p5790832.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-suppor

Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
suhas_bt022
Date:
We have tried it already.Actually there are a quite a lot of syntax changes
required .Which is making task time consuming.

You can find below statement in ora2pg website.
Ora2Pg do its best to automatically convert your Oracle database to
PostgreSQL but there's still manual works to do. The Oracle specific PL/SQL
code generated for functions, procedures, packages and triggers has to be
reviewed to match the PostgreSQL syntax.

Thanks
Suhas



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797p5790845.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
Dinesh Kumar
Date:
Hi Suhas,


On Thu, Feb 6, 2014 at 6:54 PM, suhas_bt022 <suhas_bt022@yahoo.co.in> wrote:
We have tried it already.Actually there are a quite a lot of syntax changes
required .Which is making task time consuming.

You can find below statement in ora2pg website.
Ora2Pg do its best to automatically convert your Oracle database to
PostgreSQL but there's still manual works to do. The Oracle specific PL/SQL
code generated for functions, procedures, packages and triggers has to be
reviewed to match the PostgreSQL syntax.

Oh. Sorry :)

Once i have used SQLWays kind of tool for the conversion of Oracle to PostgreSQL. But i didn't remember the name of that tool. Even the tool i have used didn't gave me 100% expected result. Still, i modified the code given by the tool as per business needs.

Hope someone will give you better tools on this.

Thanks,
Dinesh

Thanks
Suhas



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797p5790845.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support