Options

DBA xPress ›› Features ›› Data Inspector ››
Parent Previous Next

Options


Comparison Options

The comparison options apply to each comparison performed and specify how the two data sources will be compared and matched.

Setting

Description

Compare intersecting IDENTITY ranges only

When this option is set, and a comparison uses a segmented IDENTITY comparison, then only the ranges of values that are present in both databases will be compared. This can be useful for comparisons between databases where replication occurs, and the data that has not yet been replicated should be ignored. For more information, see comparison types.

Ignore computed columns by default

Ignores any column comparisons that involve computed columns by default.

Ignore ROWGUIDCOL columns by default

Ignores any column comparisons that involve ROWGUIDCOL columns by default.

Ignore non-key IDENTITY values

Ignores any column comparisons that involve IDENTITY columns when the column is not part of the comparison key.

Match objects in any schema

Allows data storage objects to be matched against data storage objects in other schema if no match is found in the same schema.

Use case-sensitive object matching

Matches data storage objects using case sensitive string matching, for databases where a case-sensitive collation is being used.

Use binary CLR type comparisons

If this option is set, then CLR type columns are compared and Synchronized using their binary representation. The default is that CLR type columns are compared and Synchronized using their string representation.

Use segmented IDENTITY comparisons

When this option is set, and the comparison key selected for a table is a single-column index that only involves an IDENTITY column, then use segmented IDENTITY comparison. For more information, see comparison types.

IDENTITY segment block size (rows)

The block size to be used with segmented IDENTITY comparisons. For more information, see comparison types.

Ignore string case

When this option is set, then string comparisons are case-insensitive.

Trim strings for comparison

When this option is set, then leading or trailing spaces are ignored for string comparisons.

Ignore string line endings

When this option is set, then the line ending style is ignored for string comparisons.

Maximum comparison threads

Specifies the maximum number of comparison threads. When most comparisons are using either IDENTITY segment comparisons, or are index scan comparisons which are scanning the clustered index, then increasing the number of threads can significantly improve the comparison throughput.

Data read timeout (seconds)

The timeout (in seconds) used for the initial data read for any comparison.


Generation Options

The generation options apply to each synchronization performed and specify how the schema modification SQL will be generated under various circumstances.

Setting

Description

Batch separator

Specifies the batch separator that is used to delimit SQL batches. In 99.9% of cases this will want to remain as 'GO'.

Use transacted modification SQL

When this option is set, DML operations will be wrapped in a transaction in order to allow consistent updates to take place in case any updates fail.

Disable DML triggers during synchronization

When this option is set, DML triggers on target objects will be disabled during synchronization.

Disable foreign keys during synchronization

When this option is set, foreign keys on target objects will be disabled during synchronization. It is recommended to keep this option set, as disabling it may cause synchronizations which involve circular foreign keys or cross-related foreign keys to fail.

Max rows per batch

This is the maximum number of rows that will be emitted into a single batch in the synchronization SQL