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 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.