标签
PostgreSQL , Oracle
背景
2002 Porting from Oracle to PostgreSQL
Agenda
- SQL Syntax, Functions, Sequences, Etc.
- Database Server General Characteristics
- Data Types and JDBC
- Other Considerations:
- References:
2008 Porting Oracle Applications to PostgreSQL
Agenda
- Porting the SQL
- Porting Tools
- PL/SQL vs. PL/pgSQL
- Interfaces
- Project Management
2011 Oracle to Postgres Migration
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
推荐
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)
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
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
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
2017 Oracle to PostgreSQL Migrations
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)
极为详细
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
- ora2pg
- 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