Hi Fred,
Le lun. 13 avr. 2020 à 21:49, Fred Richard a écrit :
> PGSQLCommunities,
>
>
> 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.
>
> Thanks
> Fred
>
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
>
