Re: Post oracle to postgres migration verification

From: Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Sachin Pawar <getsach(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Post oracle to postgres migration verification
Date: 2025-09-10 10:46:12
Message-ID: CAJk5AtZDJgo2dgqBuraefGVFbaV3YE=DB0YuOGe7Woa+EKbShg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

So you think ora2pg isn't enough to validate?

On Wed, 10 Sept 2025, 15:58 Sachin Pawar, <getsach(at)gmail(dot)com> wrote:

> Hi Raj,
> I use DVT for such purposes.
> https://github.com/GoogleCloudPlatform/professional-services-data-validator
> 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(dot)dba09(at)gmail(dot)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?
>>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sachin Pawar 2025-09-10 11:18:39 Re: Post oracle to postgres migration verification
Previous Message Sachin Pawar 2025-09-10 10:28:40 Re: Post oracle to postgres migration verification