Subscription Validation Options (Merge Subscriptions)

Applies to: SQL Server Azure SQL Database

Use the Subscription Validation Options dialog box to specify whether validation should use a row count only or a row count and a binary checksum.

Options

Verify the row counts only
Select to validate whether the table at the Subscriber has the same number of rows as the table at the Publisher. This method does not validate that the content of the rows matches. Row count validation provides a lightweight approach to validation that can make you aware of issues with your data.

Verify the row counts and compare checksums to verify the row data
In addition to taking a count of rows at the Publisher and Subscriber, a checksum of all the data is calculated using the binary checksum algorithm. If the row count fails, the checksum is not performed. This option is not valid for Microsoft SQL Server Compact.

See Also

Validate Data at the Subscriber
Validate Replicated Data