Monday, 3 April 2017

script to validate publication



sp_publication_validation @publication=hmis_oltp_p,  @full_or_fast=2, @rowcount_only=2


EXEC sp_publication_validation    @publication    = 'pb_database_1_to_server_2_database_2',
                  @rowcount_only    = 1,  -- For SQL Server version 7.0 Subscribers, only a rowcount validation is performed.
                  @full_or_fast    = 2


Generated expected rowcount value of 6756 for tb_purchasedink_xref.

-- source table
SELECT COUNT(*) FROM tb_purchasedink_xref   -- 6756

-- dest table on other server
SELECT COUNT(*) FROM rep_tb_purchasedink_xref   -- 6751

No comments:

Post a Comment