How to confirm sycronization between primary DB and secondary DB

How can i confirm that my primary DB and secondary DB are properly syncing?
LVL 5
funnymanmikeAsked:
Who is Participating?
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
On your server, in SQL Server mgmt studio you can right click on Replication (TRee view under your database). View the local publications and right click on the publication items you are interested in...from there you have several options, but one is to "View REplication Status". Select that to see the current or latest replication status.
0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
if you are only concerned with record counts, you can
1) create a script that will do counts of each table in both databases and compare the counts.

alternatively,
if you have a modified date in the rows of a table, you can select the max(modified_date) from each table and compare as well.
 
0
 
Jagdish DevakuSr DB ArchitectCommented:
U can also check them third party tools

apex sql diff

sql delta (recommended)

0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
yes, redgate has some good db comparison as well.
0
 
funnymanmikeAuthor Commented:
so nothing internal to sql? do data comparison in general or error log?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.