Re: Post oracle to postgres migration verification - Mailing list pgsql-admin

From Sachin Pawar
Subject Re: Post oracle to postgres migration verification
Date
Msg-id CAA_xQWrMNJY5gxqhssG+FimOcmpyLrHYxrp_eB1ywsdK45V6Jw@mail.gmail.com
Whole thread Raw
In response to Re: Post oracle to postgres migration verification  (Raj <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
I haven't used ora2pg yet for data validation so cannot say. 


Rgds,
Sachin Pawar

On Wed, Sep 10, 2025, 6:46 AM Raj <rajeshkumar.dba09@gmail.com> wrote:
 So you think ora2pg isn't enough to validate?

On Wed, 10 Sept 2025, 15:58 Sachin Pawar, <getsach@gmail.com> wrote:
Hi Raj,
Please feel free to reach out to me in case of any query. Also do open an issue if you run into any issues or something is unclear. 

Rgds,
Sachin Pawar


On Wed, Sep 10, 2025 at 4:53 AM Raj <rajeshkumar.dba09@gmail.com> wrote:
Hi all,

What's the best way to compare schema and data integrity post oracle to postgres migration 

Python or shell script that connects both dbs and compare list of all objects and tell differences?

pgsql-admin by date:

Previous
From: Raj
Date:
Subject: Re: Post oracle to postgres migration verification
Next
From:
Date:
Subject: values of column source in pg_settings