Setting up replication
Hi,
I am a SQL server admin fo my company and I have the following situation:
My company has several sales offices in cities across Europe. Each office stores its own inforamtion about orders and billing in a SQL server dtabase. Central headquarters in AMtserdam stores all the info from the other locations in their SQL server. Amsterdam uses order info from the sales offices to update pricing immediately. It is imperative that central headquarters receives inforamtion from these sales offices immediately for order and pricing analysis. Lines between offices are low capacity.
What is the best solution on setting up replication?
A collegae told me to use Snapshot replication, with the head quarters as the Publisher and the sales as the immediate-updating subscribers. But I think this should be the other way around? The offices are updating information TO the head quarters, right? SO then the head-quarters should be the subscriber, right?
Thanks for the help,
Ruben
[991 byte] By [
R_oo_T] at [2008-2-15]
Snapshot replication will take a snapshot at that point of time and then replicate it through to the subscriber. And generating the snapshot can take time if the database is huge.
You can use immediate updating subscribers or Merge replication.
What you may want to do is spearate out the articles so that the ones that need immediate attention are in one publication (less I believe) and the rest in another (or again depending on the quantity and activity, you can further break it down)
This way, you can sync the imediate attention ones first and take athe appropriate action and not have to wait until all the articles are synchronized (unless you need to have the complete image from the other side to make those updates)
Also in Merge, a Central subscriber topology is not a prefered one. Please see Books On Line for more information and workarounds against this topology.
Furthermore, in Merge replication you can have download only articles wherein you can designate certain articles are read-only. There will be no updates on these articles at the subscribers and this improves performance.
