Re: Oracle to Postgres

[Sam Stearns <sam.stearns@xxxxxxx>]

Thanks Ron,

Any suggestion for plsql?

Sent from my iPhone

On Jul 22, 2024, at 10:16 PM, Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:



ora2pg certainly migrated all the data objects that we cared about (including CLOB and XML types).  That was 2-3 years ago.

Didn't ask it to migrate plsql.

On Mon, Jul 22, 2024 at 8:38 AM Peter Garza <peter.garza@xxxxxxx> wrote:

Peter GarzaPeter Garza  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@xxxxxxxxx> 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@xxxxxxx> 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