TargetChecker and PauseResumeIRGroup (VBS)

These VBScript scripts illustrate the use of PowerShell to communicate with SQDR and are compatible with the scripts with the same names supplied in SQDR v5 (which used COM to communicate with SQDR).

Usage is documented as a comment at the beginning of each script.

PowerShell 5.1 or later is required.

PauseResumeIRGroup.vbs

This script can be used to automatically pause and resume an incremental group as described in the StarQuest technical document How to Automatically Pause and Resume an SQDR Incremental Replication Group.

Usage:

C> cscript PauseResumeIRGroup.vbs <IRGroupName> 0 | 1

where 0=pause; 1=resume

TargetChecker.vbs

This script can be used to perform table validation (comparing row counts between the source and destination tables of an incremental group).

Usage:

C> cscript TargetChecker.vbs [group [subscription]]

You can use SQL wildcard characters for the group and subscription parameters; If you do not supply any parameters, the SQL wildcard character % is used for both group and subscription.

For instance, the following command will check all subscriptions in the group.

C> cscript TargetChecker.vbs mygroup %

Results are written to standard output and can be redirected to a file. The results are tab-delimited and can be imported into Excel.  

TargetChecker.sql

This Query displays the results of the TargetChecker.vbs script. Usage is documented in the SQL script itself.