Oracle to PostgreSQL Migration

• 1 Database Migration Basics
  • 1.1 Introduction to Database Migration
  • 1.2 Database Migration Outline
  • 1.3 SQL Statements
  • 1.4 SQL Clauses
  • 1.5 Data types
  • 1.6 Most Common SQL Differences
  • 1.7 Type Casting
• 2 Migrate Tables
  • 2.1 Migrating Oracle SCOTT user tables
• 3 Built-in Functions
  • 3.1 Functions Overview
  • 3.2 Similar Functions
  • 3.3 Dissimilar Functions
  • 3.4 Inconsistent Functions
• 4 NULL Handling
  • 4.1 Facts with NULL
  • 4.2 Converting pipe “||” operator
  • 4.3 NULL in Unique Constraints
• 5 SQL Commands
  • 5.1 CREATE TABLE
  • 5.2 ALTER TABLE
• 6 SQL – Oracle vs PG
  • 6.1 Migrate Joins
  • 6.2 Migrate Subqueries
  • 6.3 Migrate Hierarchical Queries
• 7 Database Objects
• 8 Transaction Handling
  • 8.1 Transaction Overview
  • 8.2 Transaction with DDL
• 9 PLSQL vs plpgsql
  • 9.1 Anonymous Block
  • 9.2 Migrating DBMS_OUTPUT.PUT_LINE
  • Migrate User defined types
• Migrating Oracle Collections
  • Convert Associative Array
  • Convert PL/SQL table
  • Convert Varray
• Miscellaneous Migration Queries
  • Constraints disable and drop