Post reply

To check the consistency of the replicated tables

  • October 23, 2008 at 4:35 pm

    #194951

    Hi guys,

    I want to check the replicated tables between the publisher and the subscriber and their record counts. Any scripts would be helpful. Can you plz tell me how to do that?

    Thanks

  • October 23, 2008 at 8:18 pm

    #888995

    This is out of the box functionality of replication. Replication will validate record counts and/or checksums of articles in a publication.

    Have a look at article "How to: Validate Data at the Subscriber (Replication Transact-SQL Programming)" in Books Online. It shows you how to do this with the relevant replication stored procedures.

    If you would rather use the GIU, have a look at article "How to: Validate Data at the Subscriber (SQL Server Management Studio)" instead. This shows you how to do the same thing but from the GIU instead of the command line.

    Either way, the results end up in the in the synchronization history for the subscription (to the publication).

  • October 24, 2008 at 4:59 pm

    #889554

    We have like different enviroments with similar kind of replication setup. So, I kinda wanted to have a script such that the record count of the article of certain publication is equivalent to the record count of the article of the subsciption.. FYI there are more publications not just a single one.

    Plz help..

  • October 26, 2008 at 3:09 am

    #889725

    sp_publication_validation

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply