SQL Server 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 »

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 »

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 »

Contributions by MigOps to PostgreSQL in 2022

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

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 …

Contributions by MigOps to PostgreSQL in 2022 Read More »

MigOps announcing the support for Babelfish on any Cloud Platform

November 1, 2021 / Migrations to PostgreSQL, SQL Server to PostgreSQL / By / , / 2 Comments

AWS has recently announced the release of Babelfish extension that supports SQL Server TDS protocol. In order to have this extension work with PostgreSQL, it required some changes to PostgreSQL. However, the original thought of having the required hooks integrated into PostgreSQL has not been considered by the PostgreSQL Community (see the discussion here). For this reason, AWS …

MigOps announcing the support for Babelfish on any Cloud Platform Read More »

Scroll to Top