Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to PostgreSQL - DWH - Mailing list pgsql-admin

From John Wiencek
Subject Re: Oracle to PostgreSQL - DWH
Date
Msg-id FC31F661-3EEE-42B4-BAD9-D55A8045F151@comcast.net
Whole thread Raw
In response to Re: Oracle to PostgreSQL - DWH  (Allan Davis <allandavisjr@gmail.com>)
Responses Re: Oracle to PostgreSQL - DWH
List pgsql-admin
Tree view
Oracle compatibility mode is the default setting when you init an EPAS database.   

Jihn

Sent from my iPad

On Feb 12, 2020, at 10:24 AM, Allan Davis <allandavisjr@gmail.com> wrote:


EnterpriseDB also has an Oracle Compatibility mode--a version of the Postgres database that has an Oracle look and feel to it.  Between this and the Migration Toolkit, 95% of Oracle "stuff" should move over without too much trouble.

(disclaimer:  I've been working for EnterpriseDB for two months)

-=ad=-

On Wed, Feb 12, 2020 at 10:31 AM John Wiencek <jwiencek3@comcast.net> wrote:
EnterpriseDB has a product called Migration Toolkit (MTK) that can do this.


John

On Feb 12, 2020, at 8:25 AM, <soumik.bhattacharjee@kpn.com> <soumik.bhattacharjee@kpn.com> wrote:

Hi Experts,
 
Greetings!!
 
Did anyone have some use cases for migrating Oracle to PostgreSQL in context to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-Oracle)
 
 
Thanks..



--
Perchance to Scream - Being frightened has never been so much fun!

Photo Gallery

Isn't a good laugh worth a nickel...?

pgsql-admin by date:

Previous
From: Allan Davis
Date:
Subject: Re: Oracle to PostgreSQL - DWH
Next
From: Mohinder Raina
Date:
Subject: Re: Oracle to PostgreSQL - DWH