At the ninth PostgreSQL Korea event this year, attended by many PostgreSQL developers and operators, Openmade Consulting's Director Lee Ji-yong introduced Open POP OTO, an automated SQL conversion/verification solution.

Since 2021, the popularity of open source databases has begun to surpass commercial databases ( db-engines.com ), and PostgreSQL is the most advanced relational database among open source databases. Reflecting the current market situation where the conversion of Oracle DBMS to open source DBMS is accelerating, DBAs and developers attending this pgDay Seoul event showed great interest in 'OpenPop O2', a solution that easily converts Oracle DBMS to PostgreSQL.

When converting to an open source DB, ▲it takes a lot of manpower and time to perform the entire process from converting SQL to verifying the converted SQL, and ▲after conversion, it is difficult to clearly and effectively compare and verify the execution results and performance of the app/SQL compared to AS-IS (existing Oracle).

'OpenPop O2' is a solution that automatically supports verification of SQL quality and performance stabilization while reducing costs by shortening the DB conversion period when converting Oracle DB to open source DB.

The main functions and features of 'OpenPop O2' are as follows:

- Automatically convert Oracle SQL to open source DB SQL

- Check the quality and execution errors of converted SQL

- Compare/verify the number of processing cases and result values with AS-IS (Oracle) for the execution results of the converted SQL

- Compare/analyze the performance changes in the execution performance of converted SQL with AS-IS (Oracle)

- Optimal index guide through SQL analysis

In addition, 'OpenPop O2' has the advantage of being able to convert SQL suitable for open source DB in a short period of time and quickly extracting error SQL at the same time as conversion, but it also provides information on the location source file of SQL that needs to be modified for error correction and performance improvement.

The function to automatically compare and verify the execution results and performance of SQL between AS-IS/TO-BE (Oracle DB/Open Source DB) in a short time for converted SQL is a unique function provided only by 'OpenPop O2' both domestically and internationally, and it reduces the burden of verification (testing) and is of great help in stabilizing the operating performance of open source DB, so the interest and expectations of DBAs and developers attending this event were high.

We hope that the Open POP OTO solution from Openmade Consulting, introduced at this year's pgDay Seoul event, will be of great help to PostgreSQL developers and operators.