Oracle to PostgreSQL

Handling Trailing Zeros With Numeric Datatype in PostgreSQL

June 8, 2022 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , / 1 Comment

While performing Oracle to Postgres migrations, we may come across many interesting conversion challenges. Sometimes, the same logic might produce a different behavior between Oracle and Postgres. Minor mistakes in such conversions may create a lot of work while fixing the application functionality. One of such mistakes is while handling trailing zeroes with numeric datatype in PostgreSQL, during …

Handling Trailing Zeros With Numeric Datatype in PostgreSQL Read More »

Contributions by MigOps to PostgreSQL in 2021

January 10, 2022 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / / Leave a Comment

Our team at MigOps, believes that the increasing open source contributions to the PostgreSQL ecosystem is the major reason for increased migrations to PostgreSQL. Several developers across the world have been spending a lot of their personal and professional time to keep the beauty of this Open Source database software active. Some organizations have even hired developers to …

Contributions by MigOps to PostgreSQL in 2021 Read More »

A short summary of the Year 2021 in the PostgreSQL ecosystem

January 9, 2022 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , / Leave a Comment

On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year – 2022. It is no wonder that PostgreSQL is the only Open Source database with a consistent increase in its adoption every year. The Year 2021 has been another milestone in the PostgreSQL world. Every user of …

A short summary of the Year 2021 in the PostgreSQL ecosystem Read More »

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 / , / 5 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 / , , / 5 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 »

Scroll to Top