Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to Postgres - Mailing list pgsql-admin

From Peter Garza
Subject Re: Oracle to Postgres
Date
Msg-id CABBmw--qZFBoTJ-tQUg3P3ZyPX+=kRJLTM6AJ3n0eS_wiKGx-Q@mail.gmail.com
Whole thread Raw
In response to Re: Oracle to Postgres  (Kashif Zeeshan <kashi.zeeshan@gmail.com>)
Responses Re: Oracle to Postgres
List pgsql-admin
Tree view
  10 hours ago
Here is a good paper  - Please note that EBT Migration Portal goes with the Postgres Advanced Server. 
Thank You

https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative

image.png

On Thu, Jul 11, 2024 at 9:18 PM Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
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
Attachment

pgsql-admin by date:

Previous
From: Muhammad Imtiaz
Date:
Subject: Re: how to perform a manual failover with patroni without applying any outstanding WAL?
Next
From: Muhammad Waqas
Date:
Subject: Re: Oracle to Postgres