Hi @Colm ,
Snapshot replication is most appropriate when data changes are substantial but infrequent and does not montior updates to the data
If you want to real time, transaction replication is a good choice
In the best case, transactional replication can be near real-time, changes that occur in the pubilsher are delivered to the subscriber as they happen(in near real-time), in addition to several factors, such as network and workload can have an impact on latency, of course, the latency you also can measure:https://learn.microsoft.com/en-us/sql/relational-databases/replication/monitor/measure-latency-and-validate-connections-for-transactional-replication?redirectedfrom=MSDN&view=sql-server-ver16
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.