PostgreSQL is an open-source relational database management system. It is widely used for storing and managing large amounts of data, and its popularity has led to the development of several tools and interfaces for interacting with it. One such interface is ODBC (Open Database Connectivity), which is a standardized API for connecting to databases. While migrating from SQL Server to PostgreSQL, we come across some questions about how to use PowerShell with Postgres. In this blog post, we will discuss about PowerShell with ODBC to interact with PostgreSQL databases. ODBC Open Database Connecti ..read more

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 PostgreSQL that are not otherwise seen in Oracle or SQL Server. Three of such data types are inet, cidr and macaddr. In this article, we shall discuss in detail about storing Network addresses in Oracle vs SQL Server vs PostgreSQL. Inspecting data before Mig ..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 the behavior of NULL and empty string in Oracle vs PostgreSQL vs SQL Server with Unique Constraint. This is the first article in our series about handling NULLS during migration from Oracle to PostgreSQL and SQL Server to Postgre ..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 the concept of SYNONYMS is not supported in Postgres. We shall now see the interesting work-arounds available in Postgres for Synonyms in Oracle. What is a Synonym in Oracle ? A Synonym in Oracle is an alias to a database ..read more

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 without needing any license as it is Open Source. In this article, we shall discuss how Indexes can be rebuilt online in PostgreSQL and compare the same with Oracle. Do not forget to read our previous articles explaining Oracle vs Postgr ..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 article, I am going to discuss about avoiding constraint violations while migrating from Oracle to PostgreSQL when DATE data type is involved. **DATE datatype in PostgreSQL does not store Time whereas Oracle stores both DATE and TIME** I ..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 column lever security in Oracle vs PostgreSQL and understand how it works in PostgreSQL. Before proceeding with this article, please remember that the failures and delays in Database Migrations can be avoided by having detailed Assess ..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 contributions supporting migrations to PostgreSQL. In this article we are going to see a summary of the year 2022 in the PostgreSQL world. It is now very common to see PostgreSQL as the migration target by both Oracle and SQL Server users. PostgreSQL has transformed from ..read more

Migrations to PostgreSQL always allow us to shareinteresting 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 reason, we may see some interesting behaviors while migrating from Oracle to PostgreSQL or SQL Server to PostgreSQL. In this article, we shall discuss in detail about DATE data type in Oracle vs PostgreSQL and SQL Server vs PostgreSQL. Oracle vs SQL Server v ..read more

We have earlier published the contributions by MigOps to PostgreSQL in 2021. MigOps has continued its momentum of Contributions to PostgreSQL in 2022. This was with the spirit of supporting users looking to PostgreSQL and adding our share on increasing PostgreSQL adoptions. In the year, 2023, MigOps aims to make more massive contributions, to support migrations of both Oracle and SQL Server to PostgreSQL. Through this article, we are going to list some of the contributions by MigOps to the PostgreSQL ecosystem in 2022. I would like to thank our CTO, Gilles Darold, for all his contributions and ..read more