Count Records

The CopyStorm/Medic Count Records tool performs a comparison of object record counts in Salesforce versus CopyStorm. This tool is provided as a sanity check for backup validation, to provide assurance that CopyStorm is copying all records properly.

Run Count Records in a GUI

To access the Count Records GUI:

  • Select “Other Tools” from the top-level menu.
  • Select “Database Validation”, then “Count Records”

The UI for the Count Records tool contains four parts:

  • The left-hand side of the dialog is used to select the tables to scan.
  • The top part of the dialog has the following parameters:
    • # of Tables to Process Concurrently.
      • Specifies how many tables the tool will process in parallel. Higher values may improve performance but increase resource usage.
    • Output To CSV (checkbox).
      • If checked, headless runs of Count Records will output tool results to STDOUT and Database Logs in CSV-compliant format.
  • The lower part of the dialog displays the progress of a record count analysis as it happens.
  • If an error is detected, a button will appear in the lower right hand corner. Click on the button to see error details and/or export the errors to a file.

Running Count Records as a Batch Job

  • Windows
    • CopyStormMedic.bat -tool countRecords -run configFile.copyStormMedic
  • Linux / Mac OS
    • sh CopyStormMedic.sh -tool countRecords -run configFile.copyStormMedic