public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sachin Pawar <[email protected]>
To: Raj <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Post oracle to postgres migration verification
Date: Wed, 10 Sep 2025 07:18:39 -0400
Message-ID: <CAA_xQWrMNJY5gxqhssG+FimOcmpyLrHYxrp_eB1ywsdK45V6Jw@mail.gmail.com> (raw)
In-Reply-To: <CAJk5AtZDJgo2dgqBuraefGVFbaV3YE=DB0YuOGe7Woa+EKbShg@mail.gmail.com>
References: <CAJk5AtZT9bFNkXdWGk_W2gbg0bN06CDCAsJvJPpkADpe9=WzgQ@mail.gmail.com>
	<CAA_xQWr6s5hhgwsWYQJUKMtpSSnpFNCO_-pVQaasrC86-LYAWA@mail.gmail.com>
	<CAJk5AtZDJgo2dgqBuraefGVFbaV3YE=DB0YuOGe7Woa+EKbShg@mail.gmail.com>

I haven't used ora2pg yet for data validation so cannot say.


Rgds,
Sachin Pawar

On Wed, Sep 10, 2025, 6:46 AM Raj <[email protected]> wrote:

>  So you think ora2pg isn't enough to validate?
>
> On Wed, 10 Sept 2025, 15:58 Sachin Pawar, <[email protected]> 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 <[email protected]> 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?
>>>
>>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Post oracle to postgres migration verification
  In-Reply-To: <CAA_xQWrMNJY5gxqhssG+FimOcmpyLrHYxrp_eB1ywsdK45V6Jw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox