Schedule - PGConf.EU 2012Migrating Oracle queries to PostgreSQL
Date: 2012-10-26
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. SpeakerOleksii Kliukin |
Platinum Sponsors
Gold Sponsors
Silver Sponsors
Related Conferences
|
