Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL

I understand! you can try with the actual version you're working with and
follow the same migration steps.

On Wed, Feb 26, 2025 at 10:52 AM Mahendra Singh <msmahendrasingh18(at)gmail(dot)com>
wrote:

> I am sure EPAS 19 is not released yet. 17.4 is the latest that I am using.
>
> Any more suggestions please.
>
> On Wed, Feb 26, 2025 at 9:07 AM Gayu thulasi <gayuthulasi24(at)gmail(dot)com>
> wrote:
>
>> Hi Mahendra Singh,
>>
>> yes, it's possible to migrate data from EPAS 19, pg_dump from EPAS and
>> restore it into PostgreSQL., but check the compatibility features.
>>
>> Reference for live compare,
>>
>>
>> https://docs.devart.com/studio-for-postgresql/comparing-synchronizing-data/compare-sync-data-from-oracle.html
>>
>> https://docs-archive.enterprisedb.com/livecompare-index/
>>
>> ora2pg is also a useful tool for migrating data from Oracle to PostgreSQL.
>>
>> --
>> Admin-pg
>>
>>
>> On Tue, Feb 25, 2025 at 8:27 PM Mahendra Singh <
>> msmahendrasingh18(at)gmail(dot)com> wrote:
>>
>>> Hello Gurus,
>>>
>>> Hope you all are doing well.
>>>
>>> I have already migrated data from Oracle 19c to EPAS 19 on Oracle Linux
>>> using EDB Migration Toolkit. Now, I want to migrate the same data to
>>> PostgreSQL community version.
>>> Is it possible to do so? If yes then how?
>>>
>>> How shall I validate the data post migration? If any tool like
>>> LiveCompare then please provide me the complete steps.
>>>
>>> Regards,
>>> Mahendra Singh - DXB
>>>
>>>
>>
>>
>>
>>
>>