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_yo4sDrmaiu0Ghyn0tvan43aA+K+HD+p6frm9+-jZvmzw@mail.gmail.com
Whole thread Raw
In response to Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL  (Mahendra Singh <msmahendrasingh18@gmail.com>)
List pgsql-admin
Tree view
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@gmail.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@gmail.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, 



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: Peter Gram
Date:
Subject: Re: Install PostgreSQL 17 by rpm
Next
From: Loles Ferrándiz DBA
Date:
Subject: Re: Install PostgreSQL 17 by rpm