PublicationAttributes PublicationAttributes PublicationAttributes Enum

Definition

Enumerates supported publication properties.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

public enum class PublicationAttributes
[System.Flags]
public enum PublicationAttributes
Public Enum PublicationAttributes
Inheritance
PublicationAttributesPublicationAttributesPublicationAttributes
Attributes

Fields

AllowAnonymous AllowAnonymous AllowAnonymous 4

Anonymous subscriptions can subscribe to the publication. Anonymous subscriptions are required if you want to create a subscription without registering the subscription at the Publisher. This is necessary for cases in which you cannot establish a SQL Server connection to the Publisher during subscription configuration.

AllowDtsTransformation AllowDtsTransformation AllowDtsTransformation 16384

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

AllowInitializationFromBackup AllowInitializationFromBackup AllowInitializationFromBackup 1048576

Subscribers can initialize a subscription to the publication from a backup rather than the initial snapshot. Supported only for transactional or snapshot replication.

AllowPartitionRealignment AllowPartitionRealignment AllowPartitionRealignment 4194304

Deletes are sent to the Subscriber when modification of the row on the Publisher causes it to change its partition and when the publication uses parameterized filters. Supported only for merge publications.

AllowPull AllowPull AllowPull 2

Subscriptions where the synchronization agent runs at the Subscriber (pull subscriptions) are supported. Required to support SQL Server Compact Subscribers.

AllowPush AllowPush AllowPush 1

Subscriptions where the synchronization agent runs at the Distributor (push subscriptions) are supported.

AllowQueuedTransactions AllowQueuedTransactions AllowQueuedTransactions 8192

Queued updating subscriptions are supported for transactional publications. Supported only for transactional publications.

AllowSubscriberInitiatedSnapshot AllowSubscriberInitiatedSnapshot AllowSubscriberInitiatedSnapshot 262144

Subscribers can initiate the snapshot process to generate the filtered snapshot for their data partition when the merge publication has parameterized filters. Supported only for merge publications.

AllowSubscriptionCopy AllowSubscriptionCopy AllowSubscriptionCopy 256

Databases that subscribe to the publication can be copied and attached to create new subscriptions. Attachable subscriptions have been deprecated.

AllowSynchronousTransactions AllowSynchronousTransactions AllowSynchronousTransactions 512

Immediate updating subscriptions are supported for transactional publications. Supported only for transactional publications.

AllowSyncToAlternate AllowSyncToAlternate AllowSyncToAlternate 131072

Subscribers can synchronize subscriptions to the merge publication with servers other than the Publisher where the subscription originated. Supported only for merge publications. This feature is deprecated and will be removed in a future release. Not supported for SQL Server Compact Subscribers.

AllowWebSynchronization AllowWebSynchronization AllowWebSynchronization 524288

Subscribers can synchronize subscriptions over the Internet using the HTTPS protocol. Supported only for merge publications. Only available with SQL Server 2005. Required to support SQL Server Compact Subscribers. For more information, see Web Synchronization for Merge Replication.

AutomaticGenerateSyncProcedures AutomaticGenerateSyncProcedures AutomaticGenerateSyncProcedures 1024

The stored procedure used by updating subscriptions to synchronize with the transactional publication is automatically generated. Supported only for transactional publications.

CentralizedConflicts CentralizedConflicts CentralizedConflicts 2048

Conflict records are stored at the Publisher. Supported only for merge publications.

CompressSnapshot CompressSnapshot CompressSnapshot 128

Snapshot files are compressed into the CAB format. Snapshot files that are larger than 2 gigabytes (GB) cannot be compressed. Not supported for SQL Server Compact Subscribers.

DecentralizedConflicts DecentralizedConflicts DecentralizedConflicts 8388608

Conflict records are stored at the Subscriber. Supported only for merge publications. Not supported for SQL Server Compact Subscribers.

DynamicFilters DynamicFilters DynamicFilters 32768

Parameterized row filters are supported on a merge publication. Supported only for a merge publication.

EnabledForActiveDirectory EnabledForActiveDirectory EnabledForActiveDirectory 4096

The attribute is EnabledForActiveDirectory.

EnabledForHeterogeneousSubscribers EnabledForHeterogeneousSubscribers EnabledForHeterogeneousSubscribers 16777216

Non- SQL Server Subscribers are supported. Supported only for transactional and snapshot publications. Only available with SQL Server 2005 and later versions.

EnabledForPeerToPeer EnabledForPeerToPeer EnabledForPeerToPeer 2097152

Peer-to-peer transactional replication is supported. Supported only for transactional publications. Only available with SQL Server 2005 and later versions.

ImmediateSync ImmediateSync ImmediateSync 16

Synchronization files for the publication are recreated each time the Snapshot Agent runs. Subscribers are able to get the synchronization files immediately if the Snapshot Agent has completed before the subscription is created. New subscriptions get the newest synchronization files generated by the most recent execution of the Snapshot Agent. When setting ImmediateSync, IndependentAgent must also be set.

IndependentAgent IndependentAgent IndependentAgent 32

Each subscription uses its own replication agent instance when synchronizing with the Publisher. Setting this option reduces latency and is the default for a transactional publication. Merge replication always uses independent agents.

InternetEnabled InternetEnabled InternetEnabled 8

Publication can be synchronized over the Internet, and file transfer protocol (FTP) can be used to transfer the snapshot files to a Subscriber. For more information, see Replication over the Internet.

KeepPartitionChanges KeepPartitionChanges KeepPartitionChanges 65536

Partition change optimizations are used when precomputed partitions cannot be used. Do not specify KeepPartitionChanges when PartitionGroupsOption is True. For more information, see Optimize Parameterized Filter Performance with Precomputed Partitions.

None None None 0

Removes all options from Attributes.

SnapshotInDefaultFolder SnapshotInDefaultFolder SnapshotInDefaultFolder 64

The snapshot files for the publication are maintained in the default folder. When SnapshotInDefaultFolder is not specified, you must specify an alternate location for the snapshot files using AltSnapshotFolder.

Remarks

The PublicationAttributes enumeration supports the FlagsAttribute option, which allows a bitwise combination of enumeration values.

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

Applies to

See Also