PostgreSQL

PowerShell with ODBC to interact with PostgreSQL (Linux and Windows)

April 17, 2023 / Migrations to PostgreSQL, PostgreSQL, SQL Server to PostgreSQL / By / , , / Leave a Comment

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 …

PowerShell with ODBC to interact with PostgreSQL (Linux and Windows) Read More »

Storing Network Addresses in Oracle vs PostgreSQL vs SQL Server

February 13, 2023 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL, SQL Server to PostgreSQL / By / , , / Leave a Comment

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 »

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 SQL Server vs PostgreSQL – DATE data type

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

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 »

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 »

Scroll to Top