Export (0) Print
Expand All
Expand Minimize

PublicationAttributes Enumeration

Enumerates supported publication properties.

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

[FlagsAttribute] 
public enum PublicationAttributes
/** @attribute FlagsAttribute() */ 
public enum PublicationAttributes
FlagsAttribute 
public enum PublicationAttributes

Member nameDescription
AllowAnonymousAnonymous subscriptions can subscribe to the publication.
AllowDtsTransformationTransformable subscriptions are supported. This feature has been deprecated and required installation of SQL Server 2000 Data Transformation Services (DTS). For more information, see Transforming Published Data.
AllowInitializationFromBackupSubscribers can initialize a subscription to the publication from a backup rather than the initial snapshot. Supported only for transactional or snapshot replication.
AllowPartitionRealignmentDeletes 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.
AllowPullSubscriptions where the synchronization agent runs at the Subscriber (pull subscriptions) are supported. Required to support SQL Server 2005 Compact Edition Subscribers.
AllowPushSubscriptions where the synchronization agent runs at the Distributor (push subscriptions) are supported.
AllowQueuedTransactionsQueued updating subscriptions are supported for transactional publications. Supported only for transactional publications.
AllowSubscriberInitiatedSnapshotSubscribers 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.
AllowSubscriptionCopyDatabases that subscribe to the publication can be copied and attached to create new subscriptions. Attachable subscriptions have been deprecated.
AllowSynchronousTransactionsImmediate updating subscriptions are supported for transactional publications. Supported only for transactional publications.
AllowSyncToAlternateSubscribers 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 2005 Compact Edition Subscribers.
AllowWebSynchronizationSubscribers 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 2005 Compact Edition Subscribers. For more information, see Web Synchronization for Merge Replication.
AutomaticGenerateSyncProceduresThe stored procedure used by updating subscriptions to synchronize with the transactional publication is automatically generated. Supported only for transactional publications.
CentralizedConflictsConflict records are stored at the Publisher. Supported only for merge publications.
CompressSnapshotSnapshot files are compressed into the CAB format. Snapshot files that are larger than 2 gigabytes (GB) cannot be compressed. Not supported for SQL Server 2005 Compact Edition Subscribers.
DecentralizedConflictsConflict records are stored at the Subscriber. Supported only for merge publications. Not supported for SQL Server 2005 Compact Edition Subscribers.
DynamicFiltersParameterized row filters are supported on a merge publication. Supported only for a merge publication.
EnabledForActiveDirectory 
EnabledForHeterogeneousSubscribersNon- SQL Server Subscribers are supported. Supported only for transactional and snapshot publications. Only available with SQL Server 2005 and later versions.
EnabledForPeerToPeerPeer-to-peer transactional replication is supported. Supported only for transactional publications. Only available with SQL Server 2005 and later versions.
ImmediateSyncSynchronization 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.
IndependentAgentEach 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.
InternetEnabledPublication 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 Implementing Replication over the Internet.
KeepPartitionChangesPartition change optimizations are used when precomputed partitions cannot be used. Do not specify KeepPartitionChanges when PartitionGroupsOption is True. For more information, see Optimizing Parameterized Filter Performance with Precomputed Partitions.
NoneRemoves all options from Attributes.
SnapshotInDefaultFolderThe 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.

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.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft