Oracle to PostgreSQL Migration

• Database Migration Basics
  • Introduction to Database Migration
  • Database Migration Outline
  • SQL Statements
  • SQL Clauses
  • Data types
  • Most Common SQL Differences
  • Type Casting
• Migrate Tables
  • Migrating Oracle SCOTT user tables
• Built-in Functions
  • Functions Overview
  • Similar Functions
  • Dissimilar Functions
  • Inconsistent Functions
• NULL Handling
  • Facts with NULL
  • Converting pipe “||” operator
  • NULL in Unique Constraints
• SQL Commands
  • CREATE TABLE
  • ALTER TABLE
• SQL – Oracle vs PG
  • Migrate Joins
  • Migrate Subqueries
  • Migrate Hierarchical Queries
• Database Objects
• Transaction Handling
  • Transaction Overview
  • Transaction with DDL
• PLSQL vs plpgsql
  • Anonymous Block
  • Migrating DBMS_OUTPUT.PUT_LINE
  • Migrate User defined types
  • Migrate Oracle standard.new_time to Postgres
• Migrating Oracle Collections
  • Convert Associative Array
  • Convert Nested table
  • Convert Varray
• Miscellaneous Migration Queries
  • Constraints disable and drop