Postgres Pro
Downloads
Home   >   mailing lists

Re: Using oracle stored procedures for postgresql database - Mailing list pgsql-general

From Jayadevan M
Subject Re: Using oracle stored procedures for postgresql database
Date
Msg-id CAFS1N4iM6UPqQZ_c8nB1_GSOwTuYsywd-Wu4Ju6Kf1CGBKYAEg@mail.gmail.com
Whole thread Raw
In response to Using oracle stored procedures for postgresql database  (nikhilruikar <nikhilruikar@gmail.com>)
List pgsql-general
Tree view
Hi,

Have a look at orafce for the plugins. Try ora2pg for initial migration. There are differences in how you execute procedures (syntax), packages are missing in PostgreSQL and so on. Please have a look at http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Oracle

Regards,
Jayadevan


On Fri, Sep 20, 2013 at 3:19 PM, nikhilruikar <nikhilruikar@gmail.com> wrote:
Hi
      I am planning to migrate oracle database to postgres. I need to know
if there are any plugins or tool with which I can use stored procedures
written in oracle schema for postgres with out changing them.

Thanks in advance



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Using-oracle-stored-procedures-for-postgresql-database-tp5771714.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

pgsql-general by date:

Previous
From: BOUVARD Aurélien
Date:
Subject: Re: Using oracle stored procedures for postgresql database
Next
From: Kaare Rasmussen
Date:
Subject: Tree structure