PullSubscription Members
Represents information at the Publisher for a subscription to a merge or a transactional publication when the Synchronization Agent runs at the Subscriber. PullSubscription is a base class from which the TransPullSubscription class and the MergePullSubscription class are derived.
The following tables list the members exposed by the PullSubscription type.
Protected Constructors
名稱 | Description | |
---|---|---|
PullSubscription | Creates a new instance of the PullSubscription class. |
頂端
Public Properties
名稱 | Description | |
---|---|---|
AgentJobId | Gets the ID of the agent job used to synchronize the subscription. | |
AgentOffload | Gets or sets whether or not the Synchronization Agent runs on a computer other than the one where the agent job was created. This property is no longer supported for Distributors running Microsoft SQL Server 2005 and later. | |
AgentOffloadServer | Gets or sets the name of the remote computer where the agent runs when using remote agent activation. | |
AgentSchedule | Gets the schedule for the agent job used to synchronize the subscription. | |
AltSnapshotFolder | Gets or sets the location where the publication snapshot files are obtained when the default snapshot location at the Distributor is not used. | |
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject) | |
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject) | |
CreateSyncAgentByDefault | Gets or sets whether or not the agent job used to start the Replication Agent to synchronize the subscription is created when the subscription is created. | |
DatabaseName | Gets or sets the name of the subscription database. | |
Description | Gets or sets a textual description of the pull subscription. | |
DistributorName | Gets or sets the instance of Microsoft SQL Server that is the Distributor and is distributing the publication to which the subscription subscribes. | |
DistributorSecurity | Gets the security context used to connect to the Distributor. | |
EnabledForSynchronizationManager | Specifies whether or not the subscription can be synchronized using Windows Synchronization Manager. | |
FtpAddress | ||
FtpLogin | ||
FtpPassword | ||
FtpPort | ||
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) | |
LastAgentDateTime | Gets the date and time when the subscription was last synchronized. | |
LastAgentStatus | Gets the status of the most recent synchronization of the subscription. | |
LastAgentSummary | Gets a summary of the result of the most recent synchronization of the subscription. | |
Name | Gets the name generated for the pull subscription. | |
PublicationDBName | Gets or sets the name of the publication database. | |
PublicationName | Gets or sets the name of the publication to which the subscription subscribes. | |
PublisherName | Gets or sets the name of the Publisher. | |
PublisherSecurity | Gets or sets the security context used by the Synchronization Agent when connecting to the Publisher. | |
SecureFtpPassword | ||
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject) | |
SubscriberSecurity | Gets the security context that is used by the Synchronization Agent when connecting to the Subscriber. | |
SubscriptionId | Gets the subscription ID value. | |
SubscriptionType | Gets whether the subscription registration is for a push, pull, or anonymous subscription. | |
SynchronizationAgentProcessSecurity | Gets the security context that is used to specify the Microsoft Windows account under which the Synchronization Agent job runs to synchronize the subscription. | |
Type | ||
UseFtp | Gets or sets whether or not the snapshot files needed to initialize the pull subscription are accessed by the Synchronization Agent using File Transfer Protocol (FTP). | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject) | |
WorkingDirectory | Gets or sets the path of the directory at the Subscriber that is used to temporarily store and decompress downloaded snapshot files. |
頂端
Public Methods
(see also Protected Methods )
名稱 | Description | |
---|---|---|
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject) | |
Create | Creates the pull subscription on the Subscriber. | |
Decouple | Decouples the referenced replication object from the server. (inherited from ReplicationObject) | |
Equals | Overloaded. (inherited from Object ) | |
GetHashCode | (inherited from Object ) | |
GetType | (inherited from Object ) | |
LastAgentJobHistoryInfo | Returns information on the last Synchronization Agent job that was run. | |
Load | Loads the properties of an existing object from the server. (inherited from ReplicationObject) | |
LoadProperties | Loads the properties of an existing object from the server. (inherited from ReplicationObject) | |
ReferenceEquals | (inherited from Object ) | |
Refresh | Reloads the properties of the object. (inherited from ReplicationObject) | |
Remove | Removes the pull subscription. | |
Script | Returns a Transact-SQL script to create or delete the pull subscription based on the current property setting of the PullSubscription object. | |
StopSynchronizationJob | Attempts to stop a running job that is synchronizing the subscription. | |
SynchronizeWithJob | Starts the agent job to synchronize the subscription. | |
ToString | (inherited from Object ) |
頂端
Protected Methods
名稱 | Description | |
---|---|---|
CheckValidCreation | (inherited from ReplicationObject ) | |
CheckValidDefinition | Overridden. | |
CustomEnabledForSyncMgr | ||
Finalize | (inherited from Object ) | |
GetChangeCommand | (inherited from ReplicationObject ) | |
GetCreateCommand | (inherited from ReplicationObject ) | |
GetDropCommand | (inherited from ReplicationObject ) | |
InitMemberVariables | ||
InternalRefresh | (inherited from ReplicationObject ) | |
MemberwiseClone | (inherited from Object ) |
頂端
請參閱
參考
PullSubscription Class
Microsoft.SqlServer.Replication Namespace