What you’ll learn in this Chapter
✓ What Oracle commands are supported in PostgreSQL
✓ How transactional handling varies in Oracle and PostgreSQL
✓ Database Migration Outline defining high level database migration
✓ How type casting is different in PostgreSQL than Oracle
Overview
Before doing database code migration, one must understand the concepts of both source and target database.
This chapter aims at giving you a comprehensive idea of the differences between Oracle and PostgreSQL databases. The deep dive to migration is followed in next chapters. However, the background to start code migration from Oracle to PostgreSQL start from this chapter.