| From: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> |
|---|---|
| To: | nikhilruikar <nikhilruikar(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Using oracle stored procedures for postgresql database |
| Date: | 2013-09-20 10:08:13 |
| Message-ID: | CAFS1N4iM6UPqQZ_c8nB1_GSOwTuYsywd-Wu4Ju6Kf1CGBKYAEg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kaare Rasmussen | 2013-09-20 11:29:29 | Tree structure |
| Previous Message | BOUVARD Aurélien | 2013-09-20 10:07:09 | Re: Using oracle stored procedures for postgresql database |