We are looking at how to best let remote users use our tools, and some of our tools require SQL Server databases.
We are planning to introduce SQL Server Transactional Replication to our main db, we want the Subscriber to be pure read only, and to be located at one of our remote sites.
Will we need to change our application so that it connects to the Publisher for write operations and to the Subscriber for read ones?
Is there anything in .Net that can help us automate this?
I assumed at the start of this investigation that SQL Server would know about the replication, and redirect user requests automatically, but somehow this doesn't seem to be the case, although I cannot find any hard proof of it in the form of documentation
See this post:
So I'm looking for recommendations and best practises about how to make our app use the correct db. Can you please help?
View Complete Post