On 2017-07-12 14:30, Stephen Russell wrote:
Why put up the data off site then now that you know it is a kluge?
Ever considered this if you have to have two? http://www.techrepublic.com/article/how-to-set-up-database-replication-with-...
I would only have one single database server for the client myself and if they have such poor Internet then I'd do it local. All that extra spaghetti to keep it local and sync it sounds like a wart that will only grow over time.
Thanks for the link, Steve! As for why not doing it local? These folks will be accessing the app and their data from various locations, so hosting it on a database they can all share is key. I'm guessing I could setup the database locally on each, and setup the replication on each to communicate to the common web database? This system uses GUIDs as the PKs for nearly all tables.