I have small db (Split FE/BE) that needs to be deployed accross our companies national WAN (Australia Wide Approx 30 sites, 60 - 80 Users).
After some testing from a few different places I have established that there is no one single location that the back end could be set-up to allow all front ends to have a suitable access speed. (Due to band width and physical locations of some remote sites.)
I have figured that the best I can do is to set up a BE on a server at each of the sites and schedule an overnight syncronisation to a Master BE located on a server. This way users will have fast connections for day to day operation and it does not matter if it takes a while to syncronise.
All of the databases that I have built have been single location or LAN deployment, thus not too many issues with connection performance between FE/BE.
Can anyone suggest a means of syncronising 30 different BE with the master each night?
Any ideas would be sensational at this point.