Currently we use terminalservers to enable remote users to work with a central LOB-application. The terminalserver is on the same LAN as the
Now my question is: what is the preferred way to replicate/mirror the database to the remote sites, so users don't need a terminalserver and can work in their local LAN.
These are my concerns:
SQL over internetis often too slow. It would however be my preferred solution because of simplicity (if internet doesn't work this will only temporary effect clients, no worry about shipping log files, etc)
Mirrorwill be removed in a future version of Microsoft SQL Server. Afaik, it leaves the mirror constantly in restore-mode so the
LOB-applicationcan't actually use, correct?
Always On availability groupslook very complicated to me but they do support
Active Secondary Replicaswhich sounds like the ability that every remote site can use it's local replica for reading and the central-db for writing. However, I wonder, does this work with all LOB-applications? And does this require a very fast and stable internet-connection? It must not fail with every short internet/VPN hick-up.
- I'm hoping for a general solution that works with 'all' Microsoft SQL-based applications (
SQL over internetdoes when internet is fast and queries are limited).
- Data needs to be read/write on remote sites. It's okay if data can't be modified in case of a broken internet/VPN connection. I was hoping that
mirroringcould do this. That modifications are committed to the principal-db but all reads are directly read from the mirror (transparant to the application / without using 2 different db-servers). A bit like
domain-controllerswork. This isn't how
- A delay of minutes would be acceptable in most LOB-applications if there is no risk off sync conflicts. I can imagine that if you work with orders, timesheets, etc. it doesn't matter if your data is a bit delayed because you are accessing it from another country.
- Assume the vendor doesn't provide a solution. I won't say they don't support it. I asked one and they didn't have plans for such a system. Their solution was to move all infrastructure (servers + desktops) to the 'cloud'. But it's just MS SQL, so I'm hoping for a better solutions. With terminal-server you can have a slow user experience with everything you do. It would be better if you just have a (small) delay in your LOB-application only, not when visiting a website or scrolling a PDF.
Any recommendations? Or is a central terminal-server the only way?
Thanks in advance.