Oracle, PostgreSQL and SQL Server support a variety of data types that are very relatable. During the process of migration from Oracle to PostgreSQL and SQL Server to PostgreSQL, we see it is not much of a difficult task in mapping data types between Oracle or SQL Server and PostgreSQL. However, there exists some interesting data types in …
Storing Network Addresses in Oracle vs PostgreSQL vs SQL Server Read More »
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 »
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 …
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 »
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 »
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 »
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 »
Migrations to PostgreSQL always allow us to share interesting information about PostgreSQL compared to databases like Oracle and SQL Server. One of such is related to the behavior of the DATE data type in Oracle vs PostgreSQL and SQL Server vs PostgreSQL. PostgreSQL is a database with a rich set of data types that follow standards. For this …
Oracle vs SQL Server vs PostgreSQL – DATE data type Read More »
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 »
On June 16 2022, a new PostgreSQL 14 minor release will be published by the PostgreSQL Global Development Group. The new PostgreSQL 14.4 release fixes an issue with all versions of PostgreSQL 14 that can lead to silent corruption of indexes. Usually, the community announces a minor version update on the second Tuesday of the second month of …
Important PostgreSQL 14 update to avoid silent corruption of indexes Read More »
