I have a requirement for a client that I have a centralised system that all his satellite branches can work on.
Currently this is a ASP.net web forms app running under IIS 7 on win 2008 RC 2 using an SQL backend.
The client has now requested that each branch have a local server, so that in the event that the internet connection is down, the branches productivity does not suffer.
His other request is that everything can be updated via the central hub and using some mechanism the updates filter down to the individual sites.
What are my options here?
I see the following as possible options:
- Multiple redundant internet connections controlled by load balancers
- SQL replication for the DB (What is better, snapshot, merge or transactional)
- Roll my own IIS sync service the periodically checks if there is a new version of the web app and downloads it (I hope there are better option than this)
- Something way better I don’t yet know about (I hope this is the one I need)
One of my clients concerns are that the branches are often in very remote areas where everything from technicians to internet is hard to find and very scarce.
Any ideas, suggestions, tips etc are welcome.