Forum OpenACS Q&A: Re: Oracle to Postgres migration

Collapse
11: Re: Oracle to Postgres migration (response to 1)
Posted by Kashif_ur-Rehman Qureshi on 05/04/07 12:12 PM
We have used ora2pg migration.
http://www.it.iitb.ac.in/~it603/post/postgresql-8.0.3/contrib/oracle/ora2pg.html

COPY command was working fine but it did not convert VIEWS at all.
It did convert triggers but change trigger definition to RULE in postgre script.
We dont understand why it did it.
We are using Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product. and Postgrees 8.2.3

We required help.

Collapse
12: Re: Oracle to Postgres migration (response to 11)
Posted by Victor Horn on 09/27/15 06:23 PM
I believe you will find all you need here:

https://wiki.postgresql.org/wiki/Main_Page