Re: [EXTERNAL] database "diff"

[Paul Sichta via Tech-talk <tech-talk at aps.anl.gov>]

Many thanks, all.

Stay safe!

-ps

On Fri, Mar 20, 2020 at 4:03 PM Sinclair, John <sinclairjw at ornl.gov> wrote:

 

Hi Paul,

 

I have attached a simple perl file which sorts db records. To compare two db files, sort one and redirect output file file1 then sort the other and redirect to file2. Then compare file1 to file2. The perl script also reports (via STDERR) duplicate records, carriage returns and unprintable characters that it finds.

 

Extension is .txt to satisfy outlook.

 

John

 

From: Tech-talk <tech-talk-bounces at aps.anl.gov> On Behalf Of Paul Sichta via Tech-talk
Sent: Friday, March 20, 2020 2:44 PM
To: tech-talk at aps.anl.gov
Subject: [EXTERNAL] database "diff"

 

We're converting our (~200) databases from gdct to vdct.  After we drag around the records in vdct to visually arrange the linked records, we want to perform a final check to compare the original and the vdct records. We plan to write a text processing program/script to do this,  but...

 

Has anyone made a tool to compare the records and their fields in two database files?  Is there a utility (in the IOC) to dump a database report that we can compare (before/after)?  Does the old dbreport extension provide reports that list a record's field information that we can compare?

 

 

We're doing this because gdct doesn't run on Linux (right?).

 

Thanks,

-ps