Hi Fred,
Le lun. 13 avr. 2020 à 21:49, Fred Richard <frichard@xxxxxxxxx> a écrit :
PGSQL Communities,We migrated Oracle 11.x Database to PostgreSQL 12.x Database on a RH Linux 7.x server.
On a different RH Linux 7.x Server, I have Oracle Client installed. Since we have many scripts developed in Oracle SQL, is it possible for the PostgreSQL 12.x DB to process the Oracle Scripts? Are there utilities or drivers that could be installed on the PostgreSQL 12.x Database or server for processing the Oracle SQL client commands? We are trying to avoid updating our Oracle Client scripts on remote servers.ThanksFred
I removed the hackers' list as this is a standard question. The question is really how far from standard SQL. If you stuck to the standard, you shouldn't have a big effort. If you didn't, the case should be evaluated more carefully and you may have a bigger challenge.
A first evaluation would be to fire the requests and see how much breaks.
You can also look at http://www.enterprisedb.com/enterprise-postgres/database-compatibility-oracle as it seems to be a (possibly commercial) valid answer.
Orafce could be another one https://github.com/orafce/orafce
I haven't tried these so I can't confirm how mature or applicable they are to your problem.
Hope it helps
Olivier
