Re: Oracle to Postgres

Peter GarzaPeter Garza 10 hours ago
<https://dat-solutions.slack.com/archives/C07ABNGBS4D/p1720746398149879?thread_ts=1720745054.429439&cid=C07ABNGBS4D>
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: image.png]

On Thu, Jul 11, 2024 at 9:18 PM Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)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(dot)stearns(at)dat(dot)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
>> [image: DAT]
>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
>>
>