Utility to find differences between databases?

Question

Question

Timothy Leavitt · Jul 11, 2017

Does anyone know of a utility to compare two databases (i.e., CACHE.DAT files) and find globals/subscripts that are different between them?

If not, I'll write one and share it.

Discussion (6)1

Log in or sign up to continue

Ray Fucillo · Jul 11, 2017

DataCheck. It's about comparing databases between two different systems, but no reason you can't use it with loopback

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

6 0

score 0 · Answer 1 · 2017-07-11T09:04:58-04:00

Vitaliy Serdtsev · Jul 11, 2017

%GCMP ?

0 0

score 0 · Answer 2 · 2017-07-11T09:09:41-04:00

That does look useful, but I'm looking to compare all the globals in two databases (the output of different but theoretically equivalent build processes) to see if some globals are present from one / missing in another or if the contents of any are different, and (if so) what the differences are.

score 1 · Answer 3 · 2017-08-24T14:01:13-04:00

Robert Cemper · Aug 24, 2017

Did it work ?

%GCMP

Compares two globals in the same or different namespace.

1 0

score 0 · Answer 4 · 2017-07-11T16:58:03-04:00

Timothy Leavitt · Jul 11, 2017

Thanks, Ray! This sounds really promising.

(To confirm: it ended up working.)

0 0

score 0 · Answer 5 · 2017-07-11T09:33:28-04:00

Export relevant globals to xml file(1 file per namespace) and compare hash sums. Also there's a lot of tools to display XML diffs if hash sums would differ.

Otherwise it's per global iteration and compare. I'd write some method to calculate global hash maybe (complete iteration and hash of keys and value). So:

Get lists of globals in both ns
Iterate over lists, and calculate hashes for each global separately
Compare lists (iterate over one list and delete each same value from both lists, all that's left is diff)
Report if global is in one list and not in the other
Report if global hashes differ across lists
(Optional) Display detailed compare for globals with different hashes