Migrating Oracle queries to PostgreSQL

[Pages:64]Migrating Oracle queries to PostgreSQL

PGConf.EU 2012 Prague, Czech Republic

October 26th

Alexey Klyukin, Command Prompt, Inc.

Photo by flickr member Nils Rinaldi ()

Why?

? Unsupported and outdated Oracle version ? PostgreSQL is mature ? Cost-effective ? Query conversion is easy

Why?

? Unsupported and outdated Oracle version ? PostgreSQL is mature ? Cost-effective ? Query conversion is easy, in theory :-)

? Oracle 8i (8.1.6) >>> PostgreSQL 9.1 ? 500GB financial database ? Oracle-specific queries and data types ? No triggers or stored procedures ? Automated QA for the conversion

How?

? Data migration ? Query migration ? Reports ? Results comparison

Data migration

? CSV dump ? Ora2Pg ? Oracle Foreign Data Wrapper (FDW) ? Cross-database replication

Query conversion

? Oracle-style outer joins ? Pseudocolumns (i.e. ROWNUM) ? START WITH ... CONNECT BY ? Oracle-specific functions

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download