To compare COUNT(*) of source and target

When this option is select, CONNX performs a count(*) from the source table, and compares it to a count(*) from the target table. If the counts don't match, then the sync is considered a failure.  

This option is most useful when used in conjunction with the Retry failed syncs option.  
 

  1. On the Settings tab, click the Error Handling sub-tab.

    ErrorHandling-COUNT.bmp
     

  2. To compare source and target table counts, click Compare COUNT(*) of source and target after sync.

Note: This option can only be selected if the sync is performed during a "batch window" and the source database remains static during that time.