When considering a database migration from Oracle to PostgreSQL, one area that requires serious deliberation is that of translating Oracle’s PL/SQL source code to PostgreSQL’s PL/pgSQL. It is a well documented fact that:

1. This translation can be very challenging due to the proprietary nature of PL/SQL.
2. The translation usually results in expensive recoding and extensive testing of the resulting procedures.
3. The functionality provided by PL/pgSQL and the semantics of the PostgreSQL server do not necessarily behave in the same manner as the Oracle server and its PL/SQL, even in cases where the syntax is comparable.

Going one step further, client code that interfaces with any translated stored database procedure will be impacted in any conversion. Given these three major issues and a myriad of other details, it is easy to understand that even though many within the Oracle user community would like to migrate from Oracle to PostgreSQL, the actual migration can be a very difficult and costly task.

Bull recently completed an Oracle to PostgreSQL migration for a large bank in South America.  In the process we developed a tool for migrating Oracle Stored Procedures that goes beyond anything previously available.  Click here for more details about how our tool was key to a successful migration.

Click here for a Demo of our PL/SQL Migration Tool


If you want to learn more about how Bull can help you migrate from Oracle to the cost savings possible with PostgreSQL, contact us.