'Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated corre'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated corre
From:       Ron <ronljohnsonjr () gmail ! com>
Date:       2023-10-27 10:28:17
Message-ID: 49939d78-0a8e-4e1d-b627-2eade49736db () gmail ! com
[Download RAW message or body]

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.
[Attachment #3 (text/html)]

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 10/27/23 03:56, Y_esteembsv-forum wrote:<br>
    <blockquote type="cite"
      cite="mid:1334708887.12132.1698396967548@mail.yahoo.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div class="ydp4e73c430yahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;">
        <div dir="ltr" data-setdir="false"><span>Hi </span><br>
        </div>
        <div dir="ltr" data-setdir="false"><span><span>Need SQL
              logic/different approach method's  to find out way's </span></span></div>
        <div dir="ltr" data-setdir="false"><span><span>a) to Implement
              check sum to validate table data is migrated correctly  </span><br>
          </span></div>
      </div>
    </blockquote>
    <br>
    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.<br>
    <br>
    Had to play a few games with capitalization in blob/bytea columns<br>
    <br>
    That way, I could verify that each table's data was identical.<br>
    <br>
    <div class="moz-signature">-- <br>
      Born in Arizona, moved to Babylonia.</div>
  </body>
</html>


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic