Post reply

how to validate publisher DB

  • July 21, 2009 at 7:29 am

    #208426

    Hi All,

    How to check through TSQL/SSMS which table is not synchronised in transactional replication?

    For eaxample: suppose table is not synchronised ,it has 100 rows in publisher but in subscriber it is showing only 10 rows.How will get to know test1 table is not synchronised?Please let me know.

    Thanks,

    Litu

  • July 21, 2009 at 8:22 am

    #1027640

    You can use the tablediff utility provided with SQL Server. A introductory article can be found HERE. You can also look it up in BOL.

    Another, and easier, option is to use Red-Gate's SQL Data Compare utility. I haven't found one that works better than this.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • July 26, 2009 at 1:18 am

    #1030250

    litu deb (7/21/2009)

    Hi All,

    How to check through TSQL/SSMS which table is not synchronised in transactional replication?

    For eaxample: suppose table is not synchronised ,it has 100 rows in publisher but in subscriber it is showing only 10 rows.How will get to know test1 table is not synchronised?Please let me know.

    Thanks,

    Litu

    use sp_publication_validation

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

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