ScriptOptions ScriptOptions ScriptOptions Enum

Definition

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

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

public enum class ScriptOptions
[System.Flags]
public enum ScriptOptions
Public Enum ScriptOptions
Inheritance
ScriptOptionsScriptOptionsScriptOptions
Attributes

Fields

Creation Creation Creation 1

Specifies that the generated script is for creating replication objects.

Deletion Deletion Deletion 2

Specifies that the script is for deleting a replication object.

DisableReplicationDB DisableReplicationDB DisableReplicationDB 524290

Specifies that the script is a deletion script that disables publishing on a database and removes any agent jobs needed for publishing.

EnableReplicationDB EnableReplicationDB EnableReplicationDB 262145

Specifies that the script is a creation script that enables publishing on a database and creates any agent jobs needed for publishing.

IncludeAgentProfiles IncludeAgentProfiles IncludeAgentProfiles 131072

Specifies that the script includes all user-defined replication agent profiles defined on the Distributor.

IncludeAll IncludeAll IncludeAll 268435196

Specifies that the script includes all possible replication objects that can exist, which is equivalent to setting all values of ScriptOptions.

IncludeArticles IncludeArticles IncludeArticles 4

Specifies that the script includes articles.

IncludeChangeDestinationDataTypes IncludeChangeDestinationDataTypes IncludeChangeDestinationDataTypes 256

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.

IncludeCreateDistributionAgent IncludeCreateDistributionAgent IncludeCreateDistributionAgent 33554432

Specifies that the script includes Distribution Agent jobs.

IncludeCreateLogreaderAgent IncludeCreateLogreaderAgent IncludeCreateLogreaderAgent 8388608

Specifies that the script includes Log Reader Agent jobs.

IncludeCreateMergeAgent IncludeCreateMergeAgent IncludeCreateMergeAgent 67108864

Specifies that the script includes Merge Agent jobs.

IncludeCreateQueuereaderAgent IncludeCreateQueuereaderAgent IncludeCreateQueuereaderAgent 16777216

Specifies that the script includes Queue Reader Agent jobs.

IncludeCreateSnapshotAgent IncludeCreateSnapshotAgent IncludeCreateSnapshotAgent 4194304

Specifies that the script includes Snapshot Agent jobs.

IncludeDisableReplicationDB IncludeDisableReplicationDB IncludeDisableReplicationDB 524288

Specifies that the script disables publishing on a database and removes any agent jobs needed for publishing.

IncludeDistributionPublishers IncludeDistributionPublishers IncludeDistributionPublishers 65536

Specifies that the script includes Publishers.

IncludeEnableReplicationDB IncludeEnableReplicationDB IncludeEnableReplicationDB 262144

Specifies that the script enables publishing on a database and creates any agent jobs needed for publishing.

IncludeGo IncludeGo IncludeGo 134217728

Specifies that the script includes the GO command at the end of a batch.

IncludeInstallDistributor IncludeInstallDistributor IncludeInstallDistributor 8192

Specifies that the script installs publishing objects at the Distributor.

IncludeMergeDynamicSnapshotJobs IncludeMergeDynamicSnapshotJobs IncludeMergeDynamicSnapshotJobs 128

Specifies that the script includes the definition of any existing partitioned snapshot jobs for merge publications with parameterized row filters.

IncludeMergeJoinFilters IncludeMergeJoinFilters IncludeMergeJoinFilters 64

Specifies that the script includes the definition of all join filters defined for a merge publication.

IncludeMergePartitions IncludeMergePartitions IncludeMergePartitions 1048576

Specifies that the script includes the definition of any existing partitions for merge publications with parameterized row filters.

IncludeMergePublicationActivation IncludeMergePublicationActivation IncludeMergePublicationActivation 2097152

Specifies that the script includes setting the status of a merge publication to active.

IncludePartialSubscriptions IncludePartialSubscriptions IncludePartialSubscriptions 32

Specifies that the script includes subscriptions to transactional publications that do not subscribe to all articles in the publication.

IncludePublicationAccesses IncludePublicationAccesses IncludePublicationAccesses 512

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.

IncludePublications IncludePublications IncludePublications 2048

Specifies that the script includes publications.

IncludePublisherSideSubscriptions IncludePublisherSideSubscriptions IncludePublisherSideSubscriptions 8

Specifies that the script includes the registration of all subscriptions at the Publisher.

IncludePullSubscriptions IncludePullSubscriptions IncludePullSubscriptions 4096

Specifies that the script includes all pull subscriptions.

IncludeRegisteredSubscribers IncludeRegisteredSubscribers IncludeRegisteredSubscribers 32768

Specifies that the script includes the registration of all Subscribers at the Publisher.

IncludeReplicationJobs IncludeReplicationJobs IncludeReplicationJobs 1024

Specifies that the script includes the definition of all SQL Server Agent jobs created by replication.

IncludeSubscriberSideSubscriptions IncludeSubscriberSideSubscriptions IncludeSubscriberSideSubscriptions 16

Specifies that the script includes the Subscriber side of all Subscribers at the Publisher.

IncludeUninstallDistributor IncludeUninstallDistributor IncludeUninstallDistributor 16384

Specifies that the script uninstalls publishing objects at the Distributor.

InstallDistributor InstallDistributor InstallDistributor 8193

Specifies a creation script that installs publishing objects at the Distributor.

None None None 0

Clears all scripting options.

UninstallDistributor UninstallDistributor UninstallDistributor 16386

Specifies a deletion script that uninstalls publishing objects at the Distributor.

Remarks

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

Applies to