Re: Oracle to Postgres migration
From: Peter Barnett <regdba_at_yahoo.com>
Date: Thu, 13 Jan 2011 13:33:49 -0800 (PST)
Message-ID: <270190.86430.qm_at_web112909.mail.gq1.yahoo.com>
We are migrating one of our warehouse applications from Oracle to Greenplum which is PostgreSQL under the covers. There is a major amount of effort required to transition to Greenplum but the database is an order of magnitude faster at a much lower cost than Oracle. We did look at EnterpriseDB but Greenplum was just much faster out of the box. We have other PostgreSQL projects where we will use the Open Source version. We did talk to a couple of consultants who spoke highly of EnterpriseDB but cautioned us to start small.
Date: Thu, 13 Jan 2011 13:33:49 -0800 (PST)
Message-ID: <270190.86430.qm_at_web112909.mail.gq1.yahoo.com>
We are migrating one of our warehouse applications from Oracle to Greenplum which is PostgreSQL under the covers. There is a major amount of effort required to transition to Greenplum but the database is an order of magnitude faster at a much lower cost than Oracle. We did look at EnterpriseDB but Greenplum was just much faster out of the box. We have other PostgreSQL projects where we will use the Open Source version. We did talk to a couple of consultants who spoke highly of EnterpriseDB but cautioned us to start small.
Pete Barnett
Database Technologies Lead
Regence
- On Thu, 1/13/11, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Subject: Oracle to Postgres migration
To: oracle-l_at_freelists.org
Date: Thursday, January 13, 2011, 10:12 AM
Folks,I am interested to know if anyone has done a migration of an Oracle database to Postgres (from EnterpriseDB http://www.enterprisedb.com/solutions/business_case.do)? This company seems to claim that most of the applications developed in Oracle could be migrated to their database. Any feedback would be appreciated. Thank youAmir
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 13 2011 - 15:33:49 CST