SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Choosing replication type and preparing for it


Choosing replication type and preparing for it

Author
Message
shila_25
shila_25
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 49
Hi all,

We have 15 servers (in different regions) and each need to work with subset of data and exchange modifications with central the server.

I have chosen merge replication with dynamic filter to partition data, therefore central server acts as publisher and 15 servers as subscriber.

The problem is that data is mainly generated at subscribers and when I want to initialize snapshot, the central server has nothing to send to subscriber. Besides, if I sync them manually for startup, it will be difficult if in the future we require to reinitialize particular subscriber because the changes at the subscriber happens a lot.

Another idea is to use central subscriber model but I'm not sure if this is the right choice.

Please advise me to choose right approach.

Many thanks in advance,

Leila
free_mascot
free_mascot
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7547 Visits: 2250
What I understood from above post is "Data gnerated at subscriber from 15 sites and replicated to central server". If this is the case central subscriber is the ideal option. And yes, you can setup 15 sites as Publishers. However if the data also publish from Central server than you can set up merge replication.

Still provide more information about the data flow and what exact issue you are having so that people can help you.

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
shila_25
shila_25
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 49
Thanks for your reply! Smile

It is exactly what you understood! By using merge replication, I think we need to configure 15 servers as subscriber. This way there will be problem for startup snapshots and later re-initialization if required.
For startup snapshot, central server is empty and has nothing to send as snapshot to subscribers. Each subscriber must send the initial data to publisher(how!? SSIS? Linked server?).
If in the future we need to re-initialize particular subscriber, all data related to that subscriber(partition) must be deleted at publisher, and send data from subscriber and re-establish replication.
What can be good solution?
Thanks again!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search