Conference Schedule - PGConf.EU 2012Back
Migrating Oracle queries to PostgreSQL
Date: Oct. 26, 2012
Based on my experience migrating a large Oracle 8i database, the talk highlights conversion of SQL queries from Oracle specific constructions to PostgreSQL. A number of products exist that helps to automate data conversion from Oracle to PostgreSQL, among the notable open-source ones are ora2pg and relatively new PostgreSQL Foreign Data Wrapper for Oracle. The talk touches them briefly and advances to the area that is less explored and automated - conversion of SQL queries. Examples are provided for different classes of queries, and subtle (often undocumented) differences are highlighted.
In addition, the talk focuses on automating the Q&A part of query conversion by showing how to build a Python application to run the queries and compare the results.