PGCon2011 - Final (2011.06.11)

PGCon 2011
The PostgreSQL Conference

Speakers
Gurjeet Singh
Schedule
Day Talks - 1 - 2011-05-19
Room DMS 1160
Start time 11:30
Duration 01:00
Info
ID 343
Event type Lecture
Track Case Studies
Language used for presentation English
Feedback

Best practices with Ora2Pg

Migrating Oracle databases to PostgresQL

Ora2Pg is a GPLv3 licensed tool used to help migrate an Oracle database to a PostgreSQL compatible database. Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate some Oracle data into a PostgreSQL database.

This talk by the author of Ora2Pg will start with an introduction to the project and its history. We will continue with the best practices using Ora2Pg for Oracle to PostgreSQL migration. We will cover much of the functionalities coming in the v7.0 release which contains significant speed improvement and new features. An overview of the future development of Ora2Pg will be provided.

The talk will also cover the basic techniques and gotchas around migrating from Oracle to PostgreSQL.