Sql 2008 merge replication using data partition option.

Question

Hi Team,

I have setup Merge replication using push subscription. Data partition is enabled. I am not sure the role of data partition in replication as it is doing the same thing as the applied filter.
Also what is the use of the folders getting created in snapshot location by
data partition.

If anyone knows,pls share with me.

Thanks
Rahul.

Answer 1

The data partition will create a snapshot which just has the data which the subscriber needs. The filter will then filter changes

occurring on the subscriber and replicate them to the publisher if they fall into the filter criteria

occurring on the publisher and replicate them to the subscriber if they fall into the filter criteria

The folders are to create individual snapshots which contain only data for that subscriber or groups of subscribers which meet the filter criteria. If they used a common folder there might be a lot of files and other subscribers data could over write another subscriber.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941