ScriptOptions 열거형

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 enum ScriptOptions

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

커뮤니티 추가 항목

추가
표시: