0

In transactional replication, at a particular point of time how can i check and confirm whether data at Publisher and Subscriber is same? I don't want to check latency/trace token - as latency will only tell how much subscriber is behind from Publisher/distributor?

Improve this question

1 Answer 1

Reset to default
1

You can do a data validation to see how out of sync you are. Details on validating data can be found in Validate Replicated Data.

You can also use the tablediff utility or SQL Data Compare to see how out of sync you are and generate a T-SQL script to bring the data back into convergence.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.