Re: Oracle to PostgreSQL - DWH

[John Wiencek <jwiencek3@xxxxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxx> wrote:

EnterpriseDB has a product called Migration Toolkit (MTK) that can do this.

John

On Feb 12, 2020, at 8:25 AM, <soumik.bhattacharjee@xxxxxxx> <soumik.bhattacharjee@xxxxxxx> 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...?