posted 9/26/2011 2:39:20 AM by Fayyaz Ahmed - Views: [24843]
Problem Statement: An organization needs to configure replication whereby it is able to send different updates to different subscribers at different locations. It should replicate a certain set of information to one subscriber as well as another set to another subscriber. It is to be ensured that subscribers are able to work offline and later synchronize the modifications with the publisher. Solution: In this scenario, merge replication would be able to meet the required goal. Use merge replication typically to meet the following requirements: Allow subscribers to modify information in an offline state and then replicate it back to the publisher. A subscriber can also replicate information to other subscribers. Provide data filtering. In data filtering, filter different updates to different subscribers at different locations. Allow information to be replicated to users who are mobile and are not always connected to the SQL Server. Provide the ability to resolve conflicts that occur during replication.
Fayyaz Ahmed (Member since: 9/8/2011 12:40:08 AM)
View Fayyaz Ahmed 's profile
Leave a comment