Перечисление ScriptOptions

Статья
02/02/2013

Enumerates options for generating scripts that are used to create or remove replication objects.

Это перечисление имеет атрибут FlagsAttribute, допускающий побитовое сочетание значений его элементов.

Пространство имен: Microsoft.SqlServer.Replication
Сборка: Microsoft.SqlServer.Rmo (в Microsoft.SqlServer.Rmo.dll)

Синтаксис

'Декларация
<FlagsAttribute> _
Public Enumeration ScriptOptions
'Применение
Dim instance As ScriptOptions

[FlagsAttribute]
public enum ScriptOptions

[FlagsAttribute]
public enum class ScriptOptions

[<FlagsAttribute>]
type ScriptOptions

public enum ScriptOptions

Элементы

	Имя элемента	Описание
	None	Clears all scripting options.
	Creation	Specifies that the generated script is for creating replication objects.
	Deletion	Specifies that the script is for deleting a replication object.
	IncludeArticles	Specifies that the script includes articles.
	IncludePublisherSideSubscriptions	Specifies that the script includes the registration of all subscriptions at the Publisher.
	IncludeSubscriberSideSubscriptions
	IncludePartialSubscriptions	Specifies that the script includes subscriptions to transactional publications that do not subscribe to all articles in the publication.
	IncludeMergeJoinFilters	Specifies that the script includes the definition of all join filters defined for a merge publication.
	IncludeMergeDynamicSnapshotJobs	Specifies that the script includes the definition of any existing partitioned snapshot jobs for merge publications with parameterized row filters.
	IncludeChangeDestinationDataTypes	Specifies that the script includes any user-defined data type mappings. This option is only supported for non-SQL Server Publishers when the IncludeArticles option is enabled.
	IncludePublicationAccesses	Specifies that the script includes all logins added to the publication access list (PAL). This option is only supported for publication creation scripts. Deleting a publication automatically removes the PAL.
	IncludeReplicationJobs	Specifies that the script includes the definition of all SQL Server Agent jobs created by replication.
	IncludePublications	Specifies that the script includes publications.
	IncludePullSubscriptions	Specifies that the script includes all pull subscriptions.
	IncludeInstallDistributor	Specifies that the script installs publishing objects at the Distributor.
	IncludeUninstallDistributor	Specifies that the script uninstalls publishing objects at the Distributor.
	IncludeRegisteredSubscribers	Specifies that the script includes the registration of all Subscribers at the Publisher.
	IncludeDistributionPublishers	Specifies that the script includes Publishers.
	IncludeAgentProfiles	Specifies that the script includes all user-defined replication agent profiles defined on the Distributor.
	IncludeEnableReplicationDB	Specifies that the script enables publishing on a database and creates any agent jobs needed for publishing.
	IncludeDisableReplicationDB	Specifies that the script disables publishing on a database and removes any agent jobs needed for publishing.
	IncludeMergePartitions	Specifies that the script includes the definition of any existing partitions for merge publications with parameterized row filters.
	IncludeMergePublicationActivation	Specifies that the script includes setting the status of a merge publication to active.
	IncludeCreateSnapshotAgent	Specifies that the script includes Snapshot Agent jobs.
	IncludeCreateLogreaderAgent	Specifies that the script includes Log Reader Agent jobs.
	IncludeCreateQueuereaderAgent	Specifies that the script includes Queue Reader Agent jobs.
	IncludeCreateDistributionAgent	Specifies that the script includes Distribution Agent jobs.
	IncludeCreateMergeAgent	Specifies that the script includes Merge Agent jobs.
	IncludeGo	Specifies that the script includes the GO command at the end of a batch.
	EnableReplicationDB	Specifies that the script is a creation script that enables publishing on a database and creates any agent jobs needed for publishing.
	DisableReplicationDB	Specifies that the script is a deletion script that disables publishing on a database and removes any agent jobs needed for publishing.
	InstallDistributor	Specifies a creation script that installs publishing objects at the Distributor.
	UninstallDistributor	Specifies a deletion script that uninstalls publishing objects at the Distributor.
	IncludeAll	Specifies that the script includes all possible replication objects that can exist, which is equivalent to setting all values of ScriptOptions.

Замечания

The ScriptOptions enumeration supports the FlagsAttribute option which allows bitwise combination of enumeration values.

См. также

Справочник

Пространство имен Microsoft.SqlServer.Replication

Поделиться через