Be familiar with the comparison and column options provided for creating a row job.
Field |
Description |
---|---|
Abort condition (rows): |
Aborts row comparison if the difference count exceeds the specified value. Valid values: 1 to 9223372036854775807. Default value:1000. |
Abort row count mismatch: |
Determines whether to abort row comparison if table row counts do not match. Valid values: true or false. Default value: false. |
Auto reconcilation: |
Indicates whether to automatically apply the reconciliation script. Valid values: true or false. Default value: false. Note: To enable AUTO_RECONCILE, set CREATE_COL_LOG to true.
|
Compare mode: |
Specifies the row comparison mode.
Default value: row_compare. |
Compress row data: |
Compresses the row data between the agent and the server. Valid values: true or false. Default value: false. |
Create column log: |
Generates a column differences log, which lists all missing, orphaned, and inconsistent row values (keys and columns). Create a column log if you want to:
Valid values: true or false. Default value: false. |
Create reconciliation script: |
Generates a reconciliation script. To use this parameter, you must also set CREATE_COL_LOG to true. Valid values: true or false. Default value: false. |
Enable row count: |
Determines whether or not to count source and target table rows before they are compared. DA server uses the row count to estimate the comparison progress and end time. Note: DA server counts rows if COMPARE_MODE is row_count. Use ENABLE_ROW_COUNT only if COMPARE_MODE is a value other than row_count.
Valid values: true or false. Default value: true. |
External sort: |
Sorts rows on the agent, thereby reducing the impact of processing the ORDER BY clause in the databases. Valid values: true or false. Default value: false. |
Hash type: |
Specifies the hash type for the comparison.
Default value: database_hash. |
Retry option: |
Specifies the retry option.
Default value: never. |
Retry delay (seconds): |
Specifies the number of seconds delay for each recomparison. Valid values: 0 to 86400. Default value: 10. |
Maximum retry: |
Specifies the total number of recomparison for rows that have differences resulting from a previous comparison. Valid values: 0 to 100. Default value: 3. |
Column Option | Value |
---|---|
Compare mode: |
Specifies for how each column is compared.
|