發行項
04/02/2012

PublicationAttributes 列舉

Enumerates supported publication properties.

此列舉有一個允許其成員值為位元組合的 FlagsAttribute 屬性。

命名空間： Microsoft.SqlServer.Replication
組件： Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
<FlagsAttribute> _
Public Enumeration PublicationAttributes
'用途
Dim instance As PublicationAttributes

[FlagsAttribute]
public enum PublicationAttributes

[FlagsAttribute]
public enum class PublicationAttributes

[<FlagsAttribute>]
type PublicationAttributes

public enum PublicationAttributes

成員

	成員名稱	說明
	None	Removes all options from Attributes.
	AllowPush	Subscriptions where the synchronization agent runs at the Distributor (push subscriptions) are supported.
	AllowPull	Subscriptions where the synchronization agent runs at the Subscriber (pull subscriptions) are supported. Required to support SQL Server Compact 3.5 SP2 Subscribers.
	AllowAnonymous	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.
	InternetEnabled	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 透過網際網路實作複寫.
	ImmediateSync	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	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.
	SnapshotInDefaultFolder	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.
	CompressSnapshot	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 3.5 SP2 Subscribers.
	AllowSubscriptionCopy	Databases that subscribe to the publication can be copied and attached to create new subscriptions. Attachable subscriptions have been deprecated.
	AllowSynchronousTransactions	Immediate updating subscriptions are supported for transactional publications. Supported only for transactional publications.
	AutomaticGenerateSyncProcedures	The stored procedure used by updating subscriptions to synchronize with the transactional publication is automatically generated. Supported only for transactional publications.
	CentralizedConflicts	Conflict records are stored at the Publisher. Supported only for merge publications.
	EnabledForActiveDirectory
	AllowQueuedTransactions	Queued updating subscriptions are supported for transactional publications. Supported only for transactional publications.
	AllowDtsTransformation	未來的 Microsoft SQL Server 版本將移除這項功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。
	DynamicFilters	Parameterized row filters are supported on a merge publication. Supported only for a merge publication.
	KeepPartitionChanges	Partition change optimizations are used when precomputed partitions cannot be used. Do not specify KeepPartitionChanges when PartitionGroupsOption is True. For more information, see 使用預先計算的資料分割最佳化參數化篩選效能.
	AllowSyncToAlternate	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 3.5 SP2 Subscribers.
	AllowSubscriberInitiatedSnapshot	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.
	AllowWebSynchronization	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 3.5 SP2 Subscribers. For more information, see 合併式複寫的 Web 同步處理.
	AllowInitializationFromBackup	Subscribers can initialize a subscription to the publication from a backup rather than the initial snapshot. Supported only for transactional or snapshot replication.
	EnabledForPeerToPeer	Peer-to-peer transactional replication is supported. Supported only for transactional publications. Only available with SQL Server 2005 and later versions. When setting EnabledForPeerToPeer, the following restrictions apply: Type must be set to Transactional. ConflictPolicy must be null Nothing nullptr unit null 參考 (在 Visual Basic 中為 Nothing) . The following options must be set: AllowInitializationFromBackup IndependentAgent The following options cannot be set: AllowAnonymous AllowDtsTransformation AllowQueuedTransactions AllowSynchronousTransactions
	AllowPartitionRealignment	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. 附註 If this attribute is not enabled, data from an old partition remains on the Subscriber. Changes made to this data on the Publisher will not replicate to this Subscriber, but changes made on the Subscriber will replicate to the Publisher. Therefore, you should treat data from an old partition as read-only data.
	DecentralizedConflicts	Conflict records are stored at the Subscriber. Supported only for merge publications. Not supported for SQL Server Compact 3.5 SP2 Subscribers.
	EnabledForHeterogeneousSubscribers	Non- SQL Server Subscribers are supported. Supported only for transactional and snapshot publications. Only available with SQL Server 2005 and later versions. When setting EnabledForHeterogeneousSubscribers, the following restrictions apply: ReplicateDdl must be set to None. AllowPush option must be set. SnapshotMethod must be BcpNative or ConcurrentNative. The following publication properties must be null Nothing nullptr unit null 參考 (在 Visual Basic 中為 Nothing) : ConflictPolicy FtpAddress FtpPassword FtpSubdirectory PostSnapshotScript PreSnapshotScript QueueType The following options cannot be set: AllowInitializationFromBackup AllowQueuedTransactions AllowSubscriptionCopy AllowSynchronousTransactions AutomaticGenerateSyncProcedures InternetEnabled EnabledForPeerToPeer