Export (0) Print
Expand All
Expand Minimize

ScriptOptions Enumeration

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.

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

[FlagsAttribute]
public enum ScriptOptions

Member nameDescription
CreationSpecifies that the generated script is for creating replication objects.
DeletionSpecifies that the script is for deleting a replication object.
DisableReplicationDBSpecifies that the script is a deletion script that disables publishing on a database and removes any agent jobs needed for publishing.
EnableReplicationDBSpecifies that the script is a creation script that enables publishing on a database and creates any agent jobs needed for publishing.
IncludeAgentProfilesSpecifies that the script includes all user-defined replication agent profiles defined on the Distributor.
IncludeAllSpecifies that the script includes all possible replication objects that can exist, which is equivalent to setting all values of ScriptOptions.
IncludeArticlesSpecifies that the script includes articles.
IncludeChangeDestinationDataTypesSpecifies 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.
IncludeCreateDistributionAgentSpecifies that the script includes Distribution Agent jobs.
IncludeCreateLogreaderAgentSpecifies that the script includes Log Reader Agent jobs.
IncludeCreateMergeAgentSpecifies that the script includes Merge Agent jobs.
IncludeCreateQueuereaderAgentSpecifies that the script includes Queue Reader Agent jobs.
IncludeCreateSnapshotAgentSpecifies that the script includes Snapshot Agent jobs.
IncludeDisableReplicationDBSpecifies that the script disables publishing on a database and removes any agent jobs needed for publishing.
IncludeDistributionPublishersSpecifies that the script includes Publishers.
IncludeEnableReplicationDBSpecifies that the script enables publishing on a database and creates any agent jobs needed for publishing.
IncludeGoSpecifies that the script includes the GO command at the end of a batch.
IncludeInstallDistributorSpecifies that the script installs publishing objects at the Distributor.
IncludeMergeDynamicSnapshotJobsSpecifies that the script includes the definition of any existing partitioned snapshot jobs for merge publications with parameterized row filters.
IncludeMergeJoinFiltersSpecifies that the script includes the definition of all join filters defined for a merge publication.
IncludeMergePartitionsSpecifies that the script includes the definition of any existing partitions for merge publications with parameterized row filters.
IncludeMergePublicationActivationSpecifies that the script includes setting the status of a merge publication to active.
IncludePartialSubscriptionsSpecifies that the script includes subscriptions to transactional publications that do not subscribe to all articles in the publication.
IncludePublicationAccessesSpecifies 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.
IncludePublicationsSpecifies that the script includes publications.
IncludePublisherSideSubscriptionsSpecifies that the script includes the registration of all subscriptions at the Publisher.
IncludePullSubscriptionsSpecifies that the script includes all pull subscriptions.
IncludeRegisteredSubscribersSpecifies that the script includes the registration of all Subscribers at the Publisher.
IncludeReplicationJobsSpecifies that the script includes the definition of all SQL Server Agent jobs created by replication.
IncludeSubscriberSideSubscriptions
IncludeUninstallDistributorSpecifies that the script uninstalls publishing objects at the Distributor.
InstallDistributorSpecifies a creation script that installs publishing objects at the Distributor.
NoneClears all scripting options.
UninstallDistributorSpecifies a deletion script that uninstalls publishing objects at the Distributor.

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

Community Additions

ADD
Show:
© 2014 Microsoft