Re: Oracle to PostgreSQL - DWH

From: Allan Davis <allandavisjr(at)gmail(dot)com>
To: John Wiencek <jwiencek3(at)comcast(dot)net>
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 16:24:23
Message-ID: CALMdmJsRZdHkU+-cqss7_Hcy4=RHYH1SzWA3eUbrqam-KeWBPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
<http://allandavisjr.blogspot.com/p/perchance-to-scream.html> - Being
frightened has never been so much fun!

Photo Gallery <http://shardsandphractures.blogspot.com/p/gallery.html>

Isn't a good laugh worth a nickel...? <http://nickelatatime.blogspot.com/>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Wiencek 2020-02-12 18:26:26 Re: Oracle to PostgreSQL - DWH
Previous Message Gurudutt Dhareshwar 2020-02-12 16:06:27 Re: Oracle to PostgreSQL - DWH