How to run ‘proutil -C cmpdb’?

George Potemkin

George Potemkin

Member
Can anyone remind me how to run ‘proutil -C cmpdb’?
proutil -C cmpdb -help
proutil <db-name> -C cmpdb <db-name1> <db-name2> [ -t | -l | -l2 ] [ -Passphrase ]

But I’m getting:
Invalid cmpdb option: <db-name1>

And with anything as <db-name>:
You must supply a database name. (940)
 
That's what I get too. This must be an undocumented feature added for tech support? I can't find any reference to it in the docs or the KB. It also isn't listed in proutil -help.
 
cmpdb exists at least since Progress V5. It was a separate executable at the beginning but later in V9 the option became a part of the _dbutil. Most recent changes were done in V11.3 (if we can trust $DLC/prohelp/msgdata).

After asking the question I remembered the correct syntax:
proutil (or dbutil) cmpdb <db-name1> <db-name2> [ -t | -l | -l2 ] [ -Passphrase ]

No needs of the -C.

-t | -l parameters extends the report:

-l:
mb-lstmod
bk-updctr

-t:
mb-biopen
mb-rltime
mb-bistate
mb-cprdate
mb-oppdate
mb-time-stamp
mb-fbdate
mb-hiwater

If no -l3 option on the command line of cmpdb the _Db and _Db-Detail table records will be skipped because we know they will be different. (see msg # 16732)

I did not remember what the -l2 did but it existed according my old notes since V9.
 
Last edited:
Interesting! Apparently it has some expectations for similarity between the databases.

Compare 2 db has fewer user areas than the Compare 1 db. (17101)
There are other cmpdb-related messages at 17102 and beyond.
 
You must log in or register to reply here.
Back
Top