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,