Oracle to PostgreSQL

Null and Empty string in Oracle vs PostgreSQL vs SQL Server

February 1, 2023 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , , / Leave a Comment

Database migrations from Oracle to PostgreSQL and SQL Server to PostgreSQL can get tricky when certain differences are not known. Unknown differences can lead to migration failures. We have earlier blogged about the behavior of DATE data type and Transaction Control statements between Oracle and SQL Server and PostgreSQL. In this article, we are going to discuss about …

Null and Empty string in Oracle vs PostgreSQL vs SQL Server Read More »

Migration of Synonyms from Oracle to PostgreSQL

January 24, 2023 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , , / Leave a Comment

You might have already seen our previous articles supporting Oracle to PostgreSQL and SQL server to PostgreSQL migrations. Our previous articles have provided solutions to some of the complexities during Oracle to PostgreSQL migrations. In this article, we are going to discuss about migration of synonyms from Oracle to PostgreSQL. The major reason behind this article is that …

Migration of Synonyms from Oracle to PostgreSQL Read More »

Online rebuild of Indexes – Oracle vs PostgreSQL

January 30, 2023 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , / Leave a Comment

Sometimes, we see Customers curious about the features of PostgreSQL and see if the features similar to Oracle exist in PostgreSQL. One of such features is the capabilities of Rebuilding an Index ONLINE. Oracle requires you to have an Enterprise License to have the capability of rebuilding an Index online. Whereas PostgreSQL allows us to rebuild Indexes online …

Online rebuild of Indexes – Oracle vs PostgreSQL Read More »

Avoiding Constraint violations while migrating Oracle to PostgreSQL – DATE data type

January 30, 2023 / Aurora PostgreSQL, Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , / Leave a Comment

Choosing a correct datatype mapping while migrating from Oracle to PostgreSQL is very important to avoid migration failures. Especially when we have date and time involved, it is very important to understand the behavior in both Oracle and PostgreSQL. We have documented about DATE datatype in Oracle vs SQL Server vs PostgreSQL in our previous article. In this …

Avoiding Constraint violations while migrating Oracle to PostgreSQL – DATE data type Read More »

Row level and Column level Security – Oracle vs PostgreSQL

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

We often get interesting questions from Customers before starting migrations from Oracle to PostgreSQL or SQL Server to PostgreSQL. One of such questions is regarding the Oracle or SQL Server alternatives for security beyond the object level. Oracle has Label security whereas SQL Server has row level security. In this article, we shall discuss about row level and …

Row level and Column level Security – Oracle vs PostgreSQL Read More »

A short summary of the Year 2022 in the PostgreSQL world

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

We have earlier posted the summary of the year 2021 in the PostgreSQL world. On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year – 2023. The year 2022 has been another great year for PostgreSQL with new features, patches to existing extensions, numerous new extensions and …

A short summary of the Year 2022 in the PostgreSQL world Read More »

Oracle vs PostgreSQL – Transaction control statements

June 13, 2022 / PostgreSQL / By / , / Leave a Comment

While migrating from Oracle to PostgreSQL, the important fact to consider is that they both are 2 different database engines. The major mistake made by organizations during the course of migration is assuming that the behavior of both Oracle and PostgreSQL are same.  One of such areas with differences between Oracle vs PostgreSQL is while working with Transaction …

Oracle vs PostgreSQL – Transaction control statements Read More »

Handling Trailing Zeros With Numeric Datatype in PostgreSQL

January 30, 2023 / 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 »

pgBackRest – Running Backup from a Standby Server

January 30, 2023 / PostgreSQL / By / , , , / Leave a Comment

In our previous blog post, we discussed how to set up pgBackrest on a single standalone PostgreSQL Instance. When you run backups on a Primary Instance, we would be utilizing the computing power of the primary instance that takes the WRITES traffic. For this reason, one may choose to shift the backup job from primary to standby. These …

pgBackRest – Running Backup from a Standby Server 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 »

Scroll to Top