0

I was working on a merge replication on SQL SERVER 2012. I have one central server with the publication and distribution configured on the same machine.I have another three machines with SQL SERVER 2012 as subscribers. The replication is working fine, however, what I want to see is the how much of the data on the central server is about to be merged to the subscribers? Is there a tool that will help me to see the data that is merged so far and data which is not yet merged?

Thanks

mox-du
  • 107
  • 9

1 Answers1

0

Microsoft provides a stored procedure sp_showpendingchanges which will provide an approximation of the pending changes that need to be replicated. Note that this stored procedure does not work well when the subscription database name is the same as the publication database name.

You can also run a data validation, use the tablediff utility, or use SQL Data Compare to determine how out of sync you are.

Brandon Williams
  • 3,695
  • 16
  • 19