February 19, 2010 at 12:48 pm
We are looking at moving to a managed hosting provider and would need to then host our production SQL server databases off site at their data center.
A problem we have though is that we have several Access databases that connect to the database and we need to do some reporting queries off the system for programs like SPSS and SAS.
What sort of options might we have to deal with this?
If we setup replication would that make sense? The data center hosts our web servers so client work happens there, but for our people that need to pull reports, etc... pushing that out over a VPN to our managed host seems like it would slow things down and cause problems in general.
If we replicated back to a local server, then they could query that.
For read only work that would be fine with mirroring, but we would also like to allow ETL updates and some data entry.
Is that going to cause massive headaches?
What is the "fastest" one can really get replication working to sync changes both directions?
If a client calls in on the phone saying they just updated their contact information, how long would our staff in the local office have to wait to see that change appear in our local database?
Does anyone else have any setups similar to this they are working with or have encountered?
February 19, 2010 at 2:27 pm
You could use transactional replication. It should not be a problem if you do not have high latency between your hosting services and your office.
-Roy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply