MigrationOracletoPostgreSQL”百家”文件集

德哥發表於2018-05-06
OracleSQL

標籤

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


相關文章