Dileep Kumar

Dileep Kumar is working as a Database Engineer at MigOps. Before joining MigOps, Dileep worked as an Application Support Engineer from 2008 to 2016 and then as a Subject Matter Expert from 2016 to 2017 at First American India, pvt, Ltd. His interest towards PostgreSQL started 5 years ago when he migrated an Oracle database to PostgreSQL and enjoyed observing the performance improvements in PostgreSQL with his tuning techniques. Since then, Dileep has been extensively working in PostgreSQL and helped several tens of customers migrate to PostgreSQL.

Porting Array length from Oracle PLSQL to PostgreSQL PLPGSQL

Migrating Oracle PL/SQL code to PostgreSQL PL/pgSQL requires a deeper understanding of the behavior in both Oracle and PostgreSQL databases. It is not only the syntax but also the behavior that is very important. Else, upon porting the PL/SQL code to PL/pgSQL, we may encounter some strange application behaviors that are difficult to trace. We would like to …

Porting Array length from Oracle PLSQL to PostgreSQL PLPGSQL Read More »

CHAR(1) to Boolean transformation while migrating to PostgreSQL

PostgreSQL supports a wide variety of data types when compared to a few commercial databases like Oracle. For performance benefits, it may be wise to choose the optimal data types supported in PostgreSQL, instead of choosing the same ones as the source, while migrating from another database. In this article, we are going to discuss one such case …

CHAR(1) to Boolean transformation while migrating to PostgreSQL Read More »

Scroll to Top