Subscription Validation Options (Merge Subscriptions)
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 introduced in Microsoft SQL Server 2000. If the row count fails, the checksum is not performed. Select this option only if all Subscribers are SQL Server 2000 or later; this option is not valid for Microsoft SQL Server Compact Edition.
See Also
Other Resources
How to: Validate Data at the Subscriber (SQL Server Management Studio)
Validating Replicated Data