PGCon2011 - Add 4 Video (2015.09.18)
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 |
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.