Migration Oracle to PostgreSQL "百家"文档集

标签

PostgreSQL , Oracle

背景

2002 Porting from Oracle to PostgreSQL

《PDF Download》

Agenda

• SQL Syntax, Functions, Sequences, Etc.
• Database Server General Characteristics
• Data Types and JDBC
• Other Considerations:
• References:

2008 Porting Oracle Applications to PostgreSQL

《PDF Download》

Agenda

• Porting the SQL
• Porting Tools
• PL/SQL vs. PL/pgSQL
• Interfaces
• Project Management

2011 Oracle to Postgres Migration

《PDF Download》

Agenda

• Schema Migration
• Data Type Migration
• Data Migration
• Business Logic Migration
• Other Objects
• Connectors / Drivers / Libraries
• Application / SQL Migration
• DBA Migration
• Tools
• Ora2pg

2012 Migrating Oracle queries to PostgreSQL

推荐

《PDF Download》

Agenda

Why?
How?
Data migration
Query conversion

2016 PostgreSQL Porting Guide

https://github.com/spacewalkproject/spacewalk/wiki/PostgreSQLPortingGuide

Agenda

• General rules
• Problems and how to solve them
  • The VARCHAR-NULL problem
  • The DECODE/NVL2 functions problem
  • The NVL function problem
  • JOIN in ANSI syntax
  • SELECT column AS alias
  • Default cast to integer
  • The sysdate problem
  • Date arithmetics
  • Triggers must return something
  • Triggers mustn't touch old if they are on insert
  • Procedure call from Hibernate
  • ORDER BY expression in DISTINCT select
  • Rownum problem
  • Subquery with no alias
  • Composite type accessing
  • Concatenating of evr
  • Global function evr_t_as_vre_simple
  • No autonomous transactions
  • NUMBER to NUMERIC
  • Calling procedures
  • SELECT UNIQUE
  • TO_NUMBER function
  • TO_DATE function
  • DELETE without FROM
  • DUAL table
  • MINUS keyword
  • Bind parameter with space
  • Portable nextval
  • Recursion with opened cursors
  • Anonymous procedural SQL blocks, in Python (backend)
  • Relation (table) does not exists
  • Inserting / writing blob in Python (backend)

2016 Migrations to PostgreSQL (from Oracle)

《PDF Download》

Agenda

• Why migrate to PostgreSQL ?
• Migration process - overview
• Preliminary Migration Analysis
• Migration challenges
• Database Design / Architecture
• High Availability challenges
• Development challenges (database)
• Database migration
• Schema Migration
• PL/SQL Migration
• Data Migration
• Migration Large Objects
• Pg_largeobjects - Limitation
• Migrating JSON Data
• Development challenges (Migrating Oracle SQLs for Application)
• SQLs Migration for application

2016 Oracle to Postgres Migration

《PDF Download》

Agenda

• part 1
  • Oracle Database ™
  • how an application interacts with an RDBMS
  • the ora2pg tool
• part 2
  • PostgreSQL features for DBAs and developers

2016 PostgreSQL for Oracle DBA

《PDF Download》

Agenda

• Mind Migration
• Some terminology
• “Architecture”
• Security
• Backup and Recovery
• High Availability / Disaster recovery
• Other unordered stuff to consider

其他 PostgreSQL for Oracle DBA

https://wiki.postgresql.org/wiki/PostgreSQL_for_Oracle_DBAs

《Become a PostgreSQL DBA》

2017 Oracle to PostgreSQL Migrations

《PDF Download》

Agenda

• Introduction
• Executive Summary
• Benefits of Migrating to PostgreSQL
• When to Migrate
• Common Database Migration Challenges and Risks
• Migration Life Cycle
• Migration Service
  • Scope of Service
  • Identifying Migration Candidates
• Analyzing Migration Candidates
• Planning a Migration
• Migrating an Application
• Testing the Application
• Production Deployment
• Conclusion
• About OpenSCG

2018 Oracle Database 11g/12c To Amazon Aurora with PostgreSQL Compatibility (9.6.x)

极为详细

《PDF Download》

Agenda

• Introduction
• Disclaimer
• Automatic Migration of Oracle Schema Objects Using the AWS Schema Conversion Tool
• Migration SQL & PL/SQL (Manual)
• Migration Tables & Indexes (Manual)
• Migration Database Objects (Manual)
• Migration Database Administration (Manual)

Oracle to PostgreSQL migration - automatic tool research

http://wiki.openbravo.com/wiki/ERP_2.50:Oracle_to_PostgreSQL_migration_-_automatic_tool_research

Agenda

• Introduction
• Guideline compliant database
• Database full of Oracle specific elements
  • Syntax
  • Data Types
  • NULL
  • Sequences
  • Other Joins
  • NLS * vs. LC *
  • ROWNUM and ROWID
  • Things That Won’t Work Directly
  • PL/SQL
    • Triggers
    • Procedures/ Functions
• Tools
  • ora2pg
    • Installation
    • Configuration
    • Execution
    • Results
  • orafce
    • Installation
    • Results
• Links
• Conclusions

Oracle to Postgres Conversion

https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion

https://wiki.postgresql.org/wiki/Oracle

Agenda

• What you should know before you begin
• Transactions
• Grammar Differences
  • Sysdate
  • The Dual Table
  • ROWNUM and ROWID
  • Sequences
  • Decode
  • NVL
  • Subquery in FROM
• Functional Differences
  • Outer Joins
  • CONNECT BY
  • NO_DATA_FOUND and TOO_MANY_ROWS
    • Data Types
  • Empty strings and NULL values
  • Numeric Types
  • Date and Time
  • CLOBs
  • BLOBs
• External Tools