We have an office in London and an office in Brighton and we need to use Navision in both places. I have looked into using TS but I am also considering having a server in both sites and using transactional replication. This would give me the advantage of all users connecting to a local server and give me an up to data backup in case one server failed.
Is this a good idea or am I barking up the wrong tree?
Does anyone have experience of this scenario?
Does the fear of data conflict make this solution unfeasible?
I would be very grateful for any information you could give me.