Re: Using oracle stored procedures for postgresql database

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема Re: Using oracle stored procedures for postgresql database
Дата
Msg-id CAFS1N4iM6UPqQZ_c8nB1_GSOwTuYsywd-Wu4Ju6Kf1CGBKYAEg@mail.gmail.com
обсуждение исходный текст
Ответ на Using oracle stored procedures for postgresql database  (nikhilruikar <nikhilruikar@gmail.com>)
Список 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@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 по дате отправления:

Предыдущее
От: BOUVARD Aurélien
Дата:
Сообщение: Re: Using oracle stored procedures for postgresql database
Следующее
От: Kaare Rasmussen
Дата:
Сообщение: Tree structure