Migrations to 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 »

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 »

How difficult is to create a database software like PostgreSQL ?

April 17, 2021 / Migrations to PostgreSQL, Oracle to PostgreSQL, PostgreSQL / By / , , / Leave a Comment

Recently on twitter, i have seen a poll by Qovery asking how hard is it to create a database like PostgreSQL. With no surprise, people mostly voted it as “Very hard”. However, the word “like” in this question is very ambiguous, as rightly said in one of the comments by Dave Cramer, who is one of the very …

How difficult is to create a database software like PostgreSQL ? Read More »

Role of Foreign Data Wrappers in Migrations to PostgreSQL

February 15, 2021 / PostgreSQL / By / , , / 3 Comments

Millions of databases are being migrated to PostgreSQL today. This is because of the liberal PostgreSQL license in particular that invited more contributions to PostgreSQL and eventually made it Enterprise Grade. I have presented and also blogged about some of the rich enterprise features as following, those are otherwise available for an additional cost with some commercial databases. …

Role of Foreign Data Wrappers in Migrations to PostgreSQL Read More »

Scroll to Top