PartitionOptions 列舉
Enumerates the ways in which data in an article is partitioned amongst subscriptions when the merge publication uses a parameterized row filter.
命名空間: Microsoft.SqlServer.Replication
組件: Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)
語法
'宣告
Public Enumeration PartitionOptions
'用途
Dim instance As PartitionOptions
public enum PartitionOptions
public enum class PartitionOptions
type PartitionOptions
public enum PartitionOptions
成員
成員名稱 | 說明 | |
---|---|---|
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. | |
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. |
備註
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.
請參閱
參考
Microsoft.SqlServer.Replication 命名空間