Tuesday, August 04, 2009 9:39 AM
HI all, Long time listener, first time caller as they say :D Right - i know very little about sql and i have been asked some questions related to it, allow me to explain a little
or does it all depend on how often you set the satellite sql servers to synchronise their data....
Forgive me if this all seems a little garbled - as really my knowledge of sql extends as far as installing it and running backups using the maintenance plan lol
Tuesday, August 04, 2009 10:32 AMJed,
It sounds like you want replication setup between branch offices and a central hosting provider (or datacenter). It is very possible to do this with your own software and not replicate but use another installation of sql server to do periodic or near real time updates, but there would be no need to reinvent the wheel. This is an overview for 2008: HERE
There are a few different types of replication of which I would focus on Transactional and Merge. From what it sounds like in your post, I believe you'll want to look more specifically at transactional replication, such as peer-to-peer.
Hope this helps,