Oracle to PostgreSQL

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL – Benchmarking

November 26, 2021 / Aurora PostgreSQL, Migrations to PostgreSQL, Oracle to PostgreSQL / By / / 1 Comment

This article is to help you understand that you should benchmark before choosing Aurora PostgreSQL over PostgreSQL. We have often noticed that a lot of Customers migrating from Oracle to PostgreSQL get confused between PostgreSQL and Aurora PostgreSQL. Majority of leaders and key decision makers incline towards Aurora PostgreSQL as it is often marketed as 3 times faster …

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL – Benchmarking Read More »

PostgreSQL 15 will include some more regexp functions

November 15, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , / Leave a Comment

While migrating from other databases like Oracle to PostgreSQL, we may come across some functionalities that may be only available with a complex work-around. At MigOps, we have migrated many customers from Oracle to PostgreSQL and I have personally seen many scenarios where direct equivalent is not possible. One of them was while working with regular expressions. There …

PostgreSQL 15 will include some more regexp functions Read More »

Migration Management and schema version control in PostgreSQL

October 25, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , / Leave a Comment

Version control of any code is essential for every organization. All organizations use their own preferred tools like git, svn, perforce etc. As I was working on a new requirement, which is about porting the current CI/CD pipeline to PostgreSQL, I needed to look for a tool which will take care of the schema changes. In this use …

Migration Management and schema version control in PostgreSQL Read More »

Organizing PostgreSQL codebase using templates in Golang

October 22, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , / 3 Comments

While migrating to PostgreSQL, have you ever wondered whether you could make changes to SQL-only code without triggering a build, re-deployment, or even a restart? Have you ever attempted packaging software as a binary and allowing clients to execute their own compatible queries on any DB engine at no additional cost? In such cases, a better approach to …

Organizing PostgreSQL codebase using templates in Golang Read More »

Stored Procedure OUT Parameters in PostgreSQL 14

October 14, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , , / 3 Comments

PostgreSQL global development group generally announces a new release every year, with several new features. With an increase in the number of contributions and contributors, the new version PostgreSQL 14 released on September 30th, 2021, with several important features.  As a developer and a database migration expert, I am happy to say that there are several developer friendly …

Stored Procedure OUT Parameters in PostgreSQL 14 Read More »

Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility

August 27, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / Leave a Comment

When you are working on Oracle to PostgreSQL migrations, one of the Oracle packages that cause conversion issues is DBMS_JOB. Traditionally, we used extensions like : pg_agent, pg_cron or more recently pg_timetable for scheduling jobs. All of these tools or extensions use a cronjob like scheduling method which does not give a full compatibility of the features provided …

Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility Read More »

Announcing Credcheck extension to enforce username and password checks in PostgreSQL

July 4, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / 3 Comments

PostgreSQL includes robust security standards around all aspects such as authentication, authorization, accounting and auditing. User management and role based segregation that satisfy enterprise standards can be implemented at ease. Similarly, organizations may be willing to enforce certain compliance around the password standards such as the minimum upper case characters or minimum number of numbers and special characters …

Announcing Credcheck extension to enforce username and password checks in PostgreSQL Read More »

Ora2PG now supports oracle_fdw to increase the data migration speed

July 2, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / 2 Comments

It has been 20 Years since i have been maintaining the Ora2Pg project, an Open Source software for Oracle to PostgreSQL migrations. The first version of Ora2Pg released on 9th May, 2001. Since then, there have been several features related to schema conversions and data migrations. Over a period of time, i have witnessed several tens of thousands …

Ora2PG now supports oracle_fdw to increase the data migration speed Read More »

Global Temporary Table in PostgreSQL

June 16, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / Leave a Comment

One of the common problems while migrating from Oracle to PostgreSQL is the need of Global Temporary Tables in PostgreSQL (GTT). There is no PostgreSQL equivalent for global temporary tables. Due to this reason, I have originally started the developed of an extension called : PGTT, to reduce the overall efforts involved while migrating from Oracle to PostgreSQL. …

Global Temporary Table in PostgreSQL Read More »

Porting Array length from Oracle PLSQL to PostgreSQL PLPGSQL

May 19, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / Leave a Comment

Migrating Oracle PL/SQL code to PostgreSQL PL/pgSQL requires a deeper understanding of the behavior in both Oracle and PostgreSQL databases. It is not only the syntax but also the behavior that is very important. Else, upon porting the PL/SQL code to PL/pgSQL, we may encounter some strange application behaviors that are difficult to trace. We would like to …

Porting Array length from Oracle PLSQL to PostgreSQL PLPGSQL Read More »

Scroll to Top