--- title: "Verifier Options Dialog" slug: "verifier-options-dialog" updated: 2024-03-28T12:35:27Z published: 2024-03-28T12:35:27Z canonical: "skthelp.syniti.com/verifier-options-dialog" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Verifier Options Dialog Use the Verifier Options dialog to determine the number of rows to process and display, and to customize the way that source and target tables are compared. If you make changes to settings in this dialog, they only apply to activity in the current Verifier tab. To retain the settings for all Verifier actions, click **Apply Settings to Metadata** in the dialog. These settings will then also be available in the Preferences tab of the [Replication Properties dialog](/v1/docs/replication-properties-dialog). ## General Tab ### Run Verification Automatically Unchecked by default. Start the verification process using the ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/961cbc5c-c882-4a26-b675-a1a6d69abff0.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A36Z&se=2026-11-17T20%3A29%3A36Z&sr=b&sp=r&sig=VVbINps9uuOyLDOSq2ITbthiRhEpKHUAe3r1t3ihrA0%3D) **Run Verification** button on the Verifier tab. Check this option if you want to start the verification process automatically in the Verifier tab when you select a replication in the Metadata Explorer, and choose Verify Replication from the right mouse button menu. ### Show Source and Target Table in the Grid Checked by default. When checked, the source and target table contents are displayed in the Verifier tab for easy comparison of rows. However, if you know that your table contains large amounts of data, you may want to view only the summary in the Details pane in the Verifier. ### Max Number of Comparisons Unchecked by default. This option allows you to control the maximum number of records to compare. When checked, the default is set to 10,000. The default value can be managed in the [Replication Properties dialog](/v1/docs/replication-properties-dialog). ### Max Rows to Manage in Grid The default value is 10,000. This is the total number of rows to retrieve/view in the Verifier. This number can be modified in accordance with the memory and CPU configuration of your computer. ### Show Differences Only Checked by Default. This option allows you to control if all records in the source and target tables are displayed in the Verifier tab, or only those records that contain differences. Uncheck the option to display all records. ### Colors Use these three fields to select colors to be used for source table rows, target table rows and conflicts found during the comparison process. ## Comparison Tab ### Verify Primary Key Only Unchecked by default. When checked, the Verifier compares only the primary key field value(s) in source and target tables to determine differences between the tables. Note that **Reconcile Data** is not enabled when Verify Primary Key Only has been selected because differences and column data are not recorded during the operation to compare primary keys only. ### Verify With Pivot Columns Unchecked by default. When checked, select a column name (must be a Date, Time or Timestamp type) to use in filtering the rows to be verified. This can be used to reduce the number of records verified. For example, if a Timestamp column is specified, a where condition is created in the verification to extract the rows on source and target that were changed after the most recent timestamp. ### Verify Subset of Columns Unchecked by default. When checked, select one or more column names to use in filtering the rows to be verified. Primary keys are included in the selected columns by default. This can be used to reduce the number of records verified. ## Data Types Tab ### Record Count Only Unchecked by default. When checked, the verification process compares only the number of records in the source and target tables. ### Skip/Ignore BLOB/CLOB Unchecked by default. Any BLOB/CLOB field values will be included when comparing source and target tables. This option is unchecked by default, but comparing BLOB/CLOB values can be very time consuming so you may want to change the setting. ### Skip/Ignore Array of Bytes Unchecked by default. Any Byte Array field values will be included when comparing source and target tables. ### Trim Chars Checked by default. This option provides a way for the tool to ignore blank characters in string values. Some databases set string values at a fixed length using blank spaces to fill the string, while others permit strings of different lengths. If you check this option, the tool trims all strings with fixed string length, then compares the strings. ### Skip/Ignore Date Time When selected, any Date Time field values will be ignored when comparing source and target tables. This is because databases may store these values in different formats, so a verification might show a difference where there is no difference in the actual value, just the format in which it is stored. ### Skip/Ignore Time When selected, any Time field values will be ignored when comparing source and target tables. This is because databases may store these values in different formats, so a comparison might show a difference where there is no difference in the actual value, just the format in which it is stored. ### Number of Fractional Digits Selected by default, with the value 0. Specifically for time values, this option allows you to determine how many digits to the right of the decimal point you wish to use in comparing field values. ## Conditions ### WHERE Condition Provides fields for both source and target tables to type in a condition to narrow the number of rows compared and reported. Type the SQL syntax that you would use following the "WHERE" condition in a SQL statement. ### ORDER BY Clause The default ORDER BY clause in the Verifier is to order by primary key. However, this can be problematic when the primary key is a string because database providers can order strings differently. This field allows you to override the default ORDER BY clause by typing a single column name, or a list of comma-separated column names. ## Reconcile Tab By default, all inserts, updates and deletes are reconciled. On this tab you can check/uncheck Insert, Update and/or Delete operations. ## Apply Settings to Metadata Button Click this button to save these settings for future verification activities. Settings are saved and visible in the [Replication Properties Verifier](/v1/docs/replication-properties-dialog#verifier) tab. ## Opening the Verifier Options Dialog 1. In the Metadata Explorer, select a replication. 2. From the right mouse button menu, choose **Verify Replication**. 3. In the Verifier tab toolbar, click ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/fb320962-739b-43cc-ba39-dd7cc0044694.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A36Z&se=2026-11-17T20%3A29%3A36Z&sr=b&sp=r&sig=EKCh05NktV0wlV8Cub%2FOpNmZsIZ8s3r3LVt%2BLCFkNws%3D) **Options**. **Related Topics** [Verifier](/v1/docs/verifier) [Verifying Replication Results](/v1/docs/verifying-replication-results-verifying-replication-results) [Resolving Differences in Results](/v1/docs/reconciling-data-differences-in-results) [Saving and Reloading Comparisons](/v1/docs/saving-and-reloading-comparisons) [Analyzing Results](/v1/docs/analyzing-results)