How about creating/projecting a temp table with a primary key that includes
all the (relevant) columns.
Load your row(s) from one database then attempt to load the equivalent
row(s) from the second database.
Any rows that succeed are not the same while any that fail are.
Regards,
Alastair.
--------------------------------------------------
From: "Wills, Steve" <[email protected]>
Sent: Tuesday, June 08, 2010 11:32 AM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Record-To-Record Equality Test?
Does anyone know of a means to compare two records, in toto, for
equality||inequality?
The records have exactly the same structure, including column names and
PK, and have a 1:1 relationship.
One record comes from a local table and represents the data as it was at
its original INSERTion or most recent UPDATE. The other record is in a
view, populated by the data as it currently exists in a production
database. It might or might not have changed since the most recent
refresh of the local data.
I would like to find a way to take a "management by exception" approach to
by means of a record-by-record comparison between the pair of records.
Then, if there is a difference, dig into the nature of the inequality.
IOW, for any PK, is #RecordInLocalTable = #RecordInProductionView? If
equal, get next PK-matched pair of records. If not, then lather, rinse,
repeat.
Thanks,
Steve in Memphis
