I have two SQL Server 2005 standard Edition SP2. Where one server act as master database and other as replication database.
I have setup transactional replication between master and replication database. also i have written one stored procedure which check the total number of the records in master and replication database.
Now my requirement is to verify data between two server are in synch.
Let me explain with example:
I have customer table in master database has customerid:100 & customer_City:New York.
User update city to Mumbai
Now I have to verify at one point in time, may be at the end of day that customer_city of customerid:100 in replication database updated to Mumbai. In short, both master and replication databases are in synch.
Please let me know your view.
Thanks and Regards
View Complete Post