Postgres Pro
Downloads
Home   >   mailing lists

Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly - Mailing list pgsql-general

From Ron
Subject Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly
Date
Msg-id 49939d78-0a8e-4e1d-b627-2eade49736db@gmail.com
Whole thread Raw
In response to need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly  (Y_esteembsv-forum <esteembsv-forum@yahoo.com>)
List pgsql-general
Tree view
On 10/27/23 03:56, Y_esteembsv-forum wrote:
Hi 
Need SQL logic/different approach method's  to find out way's 
a) to Implement check sum to validate table data is migrated correctly 

When migrating from Oracle to PostgreSQL, on both the Oracle side and the Postgresql side, I dumped each table (for the big ones, I split them into views) as a tab-separated value file ordered by the primary key and piped that into md5sum.

Had to play a few games with capitalization in blob/bytea columns

That way, I could verify that each table's data was identical.

--
Born in Arizona, moved to Babylonia.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly
Next
From: Dimitrios Apostolou
Date:
Subject: BRIN index maintenance on table without primary key