Re: Oracle to PostgreSQL - DWH

From: John Wiencek <jwiencek3(at)comcast(dot)net>
To: Allan Davis <allandavisjr(at)gmail(dot)com>
Cc: soumik(dot)bhattacharjee(at)kpn(dot)com, pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Oracle to PostgreSQL - DWH
Date: 2020-02-12 18:26:26
Message-ID: FC31F661-3EEE-42B4-BAD9-D55A8045F151@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)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(at)comcast(dot)net> wrote:
>> EnterpriseDB has a product called Migration Toolkit (MTK) that can do this.
>>
>>
>> John
>>
>>> On Feb 12, 2020, at 8:25 AM, <soumik(dot)bhattacharjee(at)kpn(dot)com> <soumik(dot)bhattacharjee(at)kpn(dot)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...?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mohinder Raina 2020-02-12 19:36:16 Re: Oracle to PostgreSQL - DWH
Previous Message Allan Davis 2020-02-12 16:24:23 Re: Oracle to PostgreSQL - DWH