Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

PartitionOptions Enumeration

 

Applies To: SQL Server 2016 Preview

Enumerates the ways in which data in an article is partitioned amongst subscriptions when the merge publication uses a parameterized row filter.

Namespace:   Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public enum PartitionOptions

Member nameDescription
NonOverlappingSharedBetweenSubscriptions

The filtering for the article yields non-overlapping partitions, but multiple Subscribers can receive the same partition.

NonOverlappingSingleSubscription

The filtering for the article yields non-overlapping partitions that are unique for each subscription.

Overlapping

The filtering for the article either is static or does not yield a unique subset of data for each partition, that is, an "overlapping" partition.

OverlappingDisallowOutOfPartitionDml

The partitions are overlapping, and data manipulation language (DML) updates made at the Subscriber cannot change the partition to which a row belongs.

If the source table for an article is already published in another publication, then the value of PartitionOptions must be the same for both articles.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Return to top

Community Additions

Show:
© 2015 Microsoft