Using the Source Count Button

Scope: This button can be used on source servers of any type.

The source count button can be used at any time to count the number of records on the source form/table based on the current Source Filter Query.

If no project variables are used in the query then the record count is immediately displayed in a pop-up window when the Source Count button is clicked.

If one or more variables are used in the query, then a pop-up window is displayed like this:

Enter a value for each variable then click on the Update Count button to count the number of records on the source form/table based on the query defined and the values provided for each variable.   Variables can also be set to NULL using the Set NULL button.

Whenever the variable values are changed, the user is prompted with the option to save these values as defaults for the next migration execution.

Note regarding CURRENT_EXECUTION_TIMESTAMP Variable

If the CURRENT_EXECUTION_TIMESTAMP is used in the query, it will be given a value equal to the current date/time. This can bechanged by the user, but when the query is run at execution time it will be reset to the time when the execution started.

Related Articles

CURRENT_EXECUTION_TIMESTAMP Variable