Postgres Pro
Downloads
Home   >   mailing lists

Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL - Mailing list pgsql-admin

From Gayu thulasi
Subject Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL
Date
Msg-id CAAeKs_ye9462XvoZmuaZ2f3XqVwyP-ZEeTEoLT=4RQntJ6c-PA@mail.gmail.com
Whole thread Raw
In response to Migrate data from Oracle to EPAS, EPAS to PostgreSQL  (Mahendra Singh <msmahendrasingh18@gmail.com>)
Responses Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL
List pgsql-admin
Tree view
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, 



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@gmail.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






pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: ANALYZE post-upgrade
Next
From: Mahendra Singh
Date:
Subject: Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL