Re: Oracle to Postgres - Mailing list pgsql-admin

From Kashif Zeeshan
Subject Re: Oracle to Postgres
Date
Msg-id CAAPsdheW2kDXDzM-JwDypuwJeRqJirceYfwy3U4VNZyPHvhG3g@mail.gmail.com
Whole thread Raw
In response to Oracle to Postgres  (Sam Stearns <sam.stearns@dat.com>)
Responses Re: Oracle to Postgres
List pgsql-admin
Hi Sam

There are alot of open source and proprietary solutions available, but you should choose between them carefully as cost is not the only factor.\
EDB's MTK (Migration Toolkit) and Migration Portal are solid products for this purpose.

Regards
Kashif Zeeshan

On Fri, Jul 12, 2024 at 5:02 AM Sam Stearns <sam.stearns@dat.com> wrote:
Howdy,

We have a project to migrate our Oracle databases that are hosted on an Oracle Database Appliance to Postgres hosted on a Linux VM.  Questions:

  1. Is there a tool out there that we can use to analyze resource sizing on the Appliance that will give resource sizing recommendations for the VM?
  2. Is there a schema conversion tool or similar out there that we can use to convert Oracle ==> Postgres?
Thanks,

Sam

--

Samuel Stearns
Lead Database Administrator
c: 971 762 6879 | o: 503 672 5115 | DAT.com

DAT

pgsql-admin by date:

Previous
From: Muhammad Ikram
Date:
Subject: Re: User profile
Next
From: Wasim Devale
Date:
Subject: Re: indexes on partitioned tables