To: pgsql-admin@lists.postgresql.org
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Subject: New Oracle system in our house, migration chances
Message-ID: <d57a8b83-9ea4-97e7-4b72-720932d40fc1@matrix.gatewaynet.com>
Date: Thu, 13 Jan 2022 14:25:59 +0200
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/d57a8b83-9ea4-97e7-4b72-720932d40fc1%40matrix.gatewaynet.com>
Precedence: bulk

Hi All, HPNY 2022

We acquired a new company, those guys run on Oracle 10, on AIX 5.2, both systems dating to around 2006 or so.
We would like to increase our chances of recovery in case of disaster, since those are unsupported versions of Oracle/AIX AFAIK.
The application is written on powerbuilder.

The ppl in the respective IT dept claim they have no exotic SQL inside powerbuilder. I am almost 21 years into PostgreSQL, I have done some MS SQL integration with PostgreSQL but almost no Oracle 
experience since 90's. What are my options here?

A)
1) use a tool like ora2pg and try to migrate the schema
2) try to load the data
3) migrate ORACLE code procedures and triggers (about 50 in total)
4) setup and test the app
or
B)
1) use a layer that provides DB code (procedures/triggers) compatibility and/or DDL compatibility
2) use a tool to move/migrate the schema and load data
3) setup and test the app

Any hints where to start, technical options, help to evaluate/assess various solutions/costs would be welcome.

I know this has been discussed extensively in PgSQL community, my intention is for this email to provide a platform along with my concurrent/parallel reading on the matter.

Thank you

-- 
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt