[GENERAL] Practical Application

2015-12-14 Thread Gene Poole
All, I'm looking for some real world documentation on the use of ora2pg to move from Oracle DB 11gR2 64-bit to PostgreSQL (i.e. What's the best pgsql version to use; Is it possible to use a exported copy of the Oracle DB to create a pgsql image of it; These kinds of questions). Does PGSQL func

[GENERAL] Where Can I Find...

2013-01-25 Thread Gene Poole
I'm looking for a tutorial on how to move a Oracle 11gR2 database that consists on 4 instances with table spaces spread across multiple file systems to PostgreSQL. I need to do this because most of the open source CMS packages do not play with Oracle. The amount of data stored in the four in

[GENERAL] Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64

2011-12-07 Thread Gene Poole
to take the above and move it from Oracle to PostgreSQL along with updating my JBoss 6.0 environment so it has access to the PostgreSQL databases/instances? Can someone supply me with some direction? Thanks, Gene Poole + It's impossible for everything to be true. +

[GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread gene . poole
Hat Satellite server and extracting the DDL. It will take that Oracle DDL and convert it to PostgreSQL, but only version 8.x, and we were planning on looking at the open source PostgreSQL 8. Are the differences between versions that great? Any information or help would be appreciated. Thanks, Gene Poole