public inbox for [email protected]help / color / mirror / Atom feed
Post oracle to postgres migration verification 4+ messages / 2 participants [nested] [flat]
* Post oracle to postgres migration verification @ 2025-09-10 08:53 Raj <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Raj @ 2025-09-10 08:53 UTC (permalink / raw) To: Pgsql-admin <[email protected]> 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? ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Post oracle to postgres migration verification @ 2025-09-10 10:28 Sachin Pawar <[email protected]> parent: Raj <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Sachin Pawar @ 2025-09-10 10:28 UTC (permalink / raw) To: Raj <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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? > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Post oracle to postgres migration verification @ 2025-09-10 10:46 Raj <[email protected]> parent: Sachin Pawar <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Raj @ 2025-09-10 10:46 UTC (permalink / raw) To: Sachin Pawar <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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? >> > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Post oracle to postgres migration verification @ 2025-09-10 11:18 Sachin Pawar <[email protected]> parent: Raj <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Sachin Pawar @ 2025-09-10 11:18 UTC (permalink / raw) To: Raj <[email protected]>; +Cc: Pgsql-admin <[email protected]> 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? >>> >> ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-09-10 11:18 UTC | newest] Thread overview: 4+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-09-10 08:53 Post oracle to postgres migration verification Raj <[email protected]> 2025-09-10 10:28 ` Sachin Pawar <[email protected]> 2025-09-10 10:46 ` Raj <[email protected]> 2025-09-10 11:18 ` Sachin Pawar <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox