Re: Oracle to Postgres

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(dot)garza(at)dat(dot)com> wrote:

>
> 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>
>>>
>>