Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

validating publisher data against subscriber data Expand / Collapse
Author
Message
Posted Sunday, January 10, 2010 12:31 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 4:50 AM
Points: 904, Visits: 1,883
im running a test to see how to validate data on the publisher article vs the subscriber.

Im running the below code:

begin tran
exec sp_marksubscriptionvalidation @publication = 'Customers',@subscriber = 'MYPC\instance2',@destination_DB = 'Subscriber_db'


exec sp_article_validation @publication = 'Customers',@article = 'Customer',@rowcount_only = 0


exec sp_article_validation @publication = 'Customers', @article = 'Customer',
@rowcount_only = 0, @full_or_fast = 0, @shutdown_agent = 0,
@subscription_level = 1

commit

I assumed the 1st proc call sets up validation on the subscriber. the 2nd call validates the data on the publisher and the 3rd returns the validation data(rowcount and a checksum).

I updated data on the subscriber to ensure the rowcounts would differ from the publisher but when i run teh above code i get the same results for both calls of sp_article_validation:



Generated expected rowcount value of 13 and expected checksum value of -10885695621 for Customer.
Generated expected rowcount value of 13 and expected checksum value of -10885695621 for Customer.

Can anyone tell me why the 2nd call is not returning different values, as the subscriber data is different? Do i have an incorrect understanding on how to validate publisher data vs subscriber data?

EDIT: Pardon my ignorance. thought the results would show up in the query analyzer window, but just found out they show up in the replication monitor. issue is resolved!
Post #845096
Posted Thursday, January 23, 2014 12:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:02 PM
Points: 13, Visits: 206
The article name "Customer" is same in both statements.

Example:

exec sp_article_validation @publication = 'Pub_keys', @article = 'KeyToken', @rowcount_only = 0, @full_or_fast = 0, @shutdown_agent = 0, @subscription_level = 1
exec sp_article_validation @publication = 'Pub_keys', @article = 'SymmetricKey', @rowcount_only = 0, @full_or_fast = 0, @shutdown_agent = 0, @subscription_level = 1

Post #1534222
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse