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 »
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 …
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 performing Oracle to Postgres migrations, we may come across many interesting conversion challenges. Sometimes, the same logic might produce a different behavior between Oracle and Postgres. Minor mistakes in such conversions may create a lot of work while fixing the application functionality. One of such mistakes is while handling trailing zeroes with numeric datatype in PostgreSQL, during …
Handling Trailing Zeros With Numeric Datatype in PostgreSQL Read More »
Version control of any code is essential for every organization. All organizations use their own preferred tools like git, svn, perforce etc. As I was working on a new requirement, which is about porting the current CI/CD pipeline to PostgreSQL, I needed to look for a tool which will take care of the schema changes. In this use …
Migration Management and schema version control in PostgreSQL Read More »
