MIME-Version: 1.0
References: 
 <CAJk5AtZT9bFNkXdWGk_W2gbg0bN06CDCAsJvJPpkADpe9=WzgQ@mail.gmail.com>
 <CAA_xQWr6s5hhgwsWYQJUKMtpSSnpFNCO_-pVQaasrC86-LYAWA@mail.gmail.com>
In-Reply-To: 
 <CAA_xQWr6s5hhgwsWYQJUKMtpSSnpFNCO_-pVQaasrC86-LYAWA@mail.gmail.com>
From: Raj <rajeshkumar.dba09@gmail.com>
Date: Wed, 10 Sep 2025 16:16:12 +0530
Message-ID: 
 <CAJk5AtZDJgo2dgqBuraefGVFbaV3YE=DB0YuOGe7Woa+EKbShg@mail.gmail.com>
Subject: Re: Post oracle to postgres migration verification
To: Sachin Pawar <getsach@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cc2168063e7021eb"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5AtZDJgo2dgqBuraefGVFbaV3YE%3DDB0YuOGe7Woa%2BEKbShg%40mail.gmail.com>
Precedence: bulk

--000000000000cc2168063e7021eb
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

 So you think ora2pg isn't enough to validate?

On Wed, 10 Sept 2025, 15:58 Sachin Pawar, <getsach@gmail.com> wrote:

> Hi Raj,
> I use DVT for such purposes.
> https://github.com/GoogleCloudPlatform/professional-services-data-validat=
or
> 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=E2=80=AFAM 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?
>>
>

--000000000000cc2168063e7021eb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">=C2=A0So you think ora2pg isn&#39;t enough to validate?</=
div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" c=
lass=3D"gmail_attr">On Wed, 10 Sept 2025, 15:58 Sachin Pawar, &lt;<a href=
=3D"mailto:getsach@gmail.com">getsach@gmail.com</a>&gt; wrote:<br></div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #=
ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>Hi=C2=A0Raj,</div><div>I =
use DVT for such purposes.=C2=A0<a href=3D"https://github.com/GoogleCloudPl=
atform/professional-services-data-validator" target=3D"_blank" rel=3D"noref=
errer">https://github.com/GoogleCloudPlatform/professional-services-data-va=
lidator</a></div><div>Please feel free to reach out to me in=C2=A0case of a=
ny query. Also do open an issue if you run into any issues or something is =
unclear.=C2=A0</div><div><br></div><div>Rgds,</div><div><div dir=3D"ltr" cl=
ass=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"=
><div>Sachin Pawar</div></div></div></div><br></div><br><div class=3D"gmail=
_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Sep 10, 2025 at 4:53=
=E2=80=AFAM Raj &lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com" target=
=3D"_blank" rel=3D"noreferrer">rajeshkumar.dba09@gmail.com</a>&gt; wrote:<b=
r></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"=
>Hi all,<div dir=3D"auto"><br></div><div dir=3D"auto">What&#39;s the best w=
ay to compare schema and data integrity post oracle to postgres migration=
=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Python or shell s=
cript that connects both dbs and compare list of all objects and tell diffe=
rences?</div></div>
</blockquote></div>
</blockquote></div>

--000000000000cc2168063e7021eb--