From: John Wiencek <jwiencek3@comcast.net>
To: Allan Davis <allandavisjr@gmail.com>
Cc: soumik.bhattacharjee@kpn.com
Cc: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: Oracle to PostgreSQL - DWH
Date: Wed, 12 Feb 2020 12:26:26 -0600
Message-ID: <FC31F661-3EEE-42B4-BAD9-D55A8045F151@comcast.net> (raw)
In-Reply-To: <CALMdmJsRZdHkU+-cqss7_Hcy4=RHYH1SzWA3eUbrqam-KeWBPA@mail.gmail.com>
References: <CALMdmJsRZdHkU+-cqss7_Hcy4=RHYH1SzWA3eUbrqam-KeWBPA@mail.gmail.com>
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...?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jwiencek3@comcast.net, allandavisjr@gmail.com, soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.org
Subject: Re: Oracle to PostgreSQL - DWH
In-Reply-To: <FC31F661-3EEE-42B4-BAD9-D55A8045F151@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox