ora2pgpro

2023: Product Announcement

In mid-June 2023 Postgres Professional , it introduced a utility for easy migration ON Oracle from to Russian. PostgreSQL DBMS According to the developers, the program allows you to increase the percentage of correct code conversion in automatic mode, which will help customers save up to 50% of migration time and reduce migration costs from Oracle.

Ora2pgpro is based on the open ora2pg application, a tool for converting Oracle databases to PostgreSQL, developed mainly by Gilles Darold of the French company Dalibo. Unlike a free application that converts offline transactions into wrapper functions using dblink or pg_background, the ora2pgpro utility exports offline transactions directly, several times improving their performance.

Postgres Professional introduced a utility for easy migration to PostgreSQL DBMS

Ora2pgpro is delivered as part of the next update of the Postgres Pro Enterprise 15.3.1 DBMS. In addition to the utility, a pgpro_application_info extension was also added to the new release to help migrate applications using the DBMS_APPLICATION_INFO package to Oracle.

It is noted that the decision was the next stage in Postgres Professional's work to facilitate migration from Oracle. In January 2023, the company already introduced support for packages (sets of functions and procedures) "in the style of Oracle" in the Postgres Pro Enterprise DBMS.

As noted by Ivan Panchenko, co-founder and deputy general director of Postgres Professional, Russian vendors, as a rule, do not develop solutions that emulate the functionality of Oracle system packages. Instead, they include the popular open-source extension ORAFCE in their distribution. In fact, ORAFCE implements only 5-6 packages from Oracle, while Oracle has about 200, over 20 of which are often used by customers, he said.