Re: Post oracle to postgres migration verification

From: Sachin Pawar <getsach(at)gmail(dot)com>
To: Raj <rajeshkumar(dot)dba09(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 11:18:39
Message-ID: CAA_xQWrMNJY5gxqhssG+FimOcmpyLrHYxrp_eB1ywsdK45V6Jw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(dot)dba09(at)gmail(dot)com> wrote:

> 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

Browse pgsql-admin by date

  From Date Subject
Next Message msalais 2025-09-10 19:21:10 values of column source in pg_settings
Previous Message Raj 2025-09-10 10:46:12 Re: Post oracle to postgres migration verification