TransSubscription Members
Include Protected Members
Include Inherited Members
Represents a push subscription to a transactional or snapshot publication.
The TransSubscription type exposes the following members.
Constructors
Name | Description | |
---|---|---|
TransSubscription() | Creates a new instance of the TransSubscription class. | |
TransSubscription(String, String, String, String, ServerConnection) | Creates a new instance of the TransSubscription class with the specified publication, database, Subscriber, and subscriber database, and with the specified connection to the instance of Microsoft SQL Server. |
Top
Methods
Name | Description | |
---|---|---|
CheckValidCreation() | Infrastructure. (Inherited from ReplicationObject.) | |
CheckValidDefinition(Boolean) | Infrastructure. (Inherited from Subscription.) | |
CommitPropertyChanges() | Sends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.) | |
Create() | Creates the subscription registration at the Publisher. (Inherited from Subscription.) | |
Decouple() | Decouples the referenced replication object from the server. (Inherited from ReplicationObject.) | |
Equals(Object) | (Inherited from Object.) | |
Finalize() | (Inherited from Object.) | |
GetChangeCommand(StringBuilder, String, String) | Infrastructure. (Inherited from ReplicationObject.) | |
GetCreateCommand(StringBuilder, Boolean, ScriptOptions) | Infrastructure. (Inherited from ReplicationObject.) | |
GetDropCommand(StringBuilder, Boolean) | Infrastructure. (Inherited from ReplicationObject.) | |
GetHashCode() | (Inherited from Object.) | |
GetType() | (Inherited from Object.) | |
InternalRefresh(Boolean) | Infrastructure. (Inherited from ReplicationObject.) | |
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.) | |
MemberwiseClone() | (Inherited from Object.) | |
Refresh() | Reloads the properties of the object. (Inherited from ReplicationObject.) | |
Reinitialize() | Marks the subscription for reinitialization the next time the Distribution Agent runs to synchronize the subscription. | |
Reinitialize(Boolean) | ||
Remove() | Deletes the subscription registration at the Publisher and removes replication objects at the Subscriber for a push subscription. (Inherited from Subscription.) | |
Script(ScriptOptions) | Returns a Transact-SQL script that can be used to create or delete the subscription. (Inherited from Subscription.) | |
StopSynchronizationJob() | Attempts to stop a running Distribution Agent job that is currently synchronizing the subscription. | |
SynchronizeWithJob() | Starts the agent job to synchronize the subscription. | |
ToString() | (Inherited from Object.) |
Top
Properties
Name | Description | |
---|---|---|
AgentJobId | Gets the ID of the agent job used to synchronize the subscription. (Inherited from Subscription.) | |
AgentOffload | Gets or sets whether 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. (Inherited from Subscription.) | |
AgentOffloadServer | Gets or sets the name of the remote computer where the agent runs when using remote agent activation. (Inherited from Subscription.) | |
AgentSchedule | Gets the schedule for the agent job used to synchronize the subscription. (Inherited from Subscription.) | |
BackupInformation | Gets or sets information needed to initialize a subscription from a backup. | |
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 the agent job used to synchronize the subscription is created by default. (Inherited from Subscription.) | |
DatabaseName | Gets or sets the name of the publication database. (Inherited from Subscription.) | |
DtsPackageLocation | Gets or sets the location of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package. | |
DtsPackageName | Gets or sets the name of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package that is applied at the Subscriber. | |
DtsPackagePassword | Sets the password used to run the Microsoft SQL Server 2000 Data Transformation Services (DTS) package. | |
EnabledForSynchronizationManager | Specifies whether the subscription can be synchronized using Microsoft Windows Synchronization Manager. (Inherited from Subscription.) | |
FullSubscription | Infrastructure. | |
IsExistingObject | Gets whether the object exists on the server or not. (Inherited from ReplicationObject.) | |
LoopBackDetection | Gets or sets whether or not the Distribution Agent sends transactions that originated at the Subscriber back to the Subscriber. | |
Name | Gets the name assigned to an existing subscription. (Inherited from Subscription.) | |
PublicationName | Gets or sets the name of the publication to which the subscription subscribes. (Inherited from Subscription.) | |
PublisherName | Gets or sets the name of the Publisher when the subscription belongs to a non- SQL Server Publisher. | |
SecureDtsPackagePassword | Sets the password (as a SecureString object) used to run the Microsoft SQL Server 2000 Data Transformation Services (DTS) package. | |
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.) | |
Status | Gets the status of the subscription. (Inherited from Subscription.) | |
SubscriberCatalog | Gets or sets the catalog used when making a connection to the OLE DB provider for a non-SQL Server Subscriber. | |
SubscriberDatasource | Name of the data source as understood by the OLE DB provider for a non-SQL Server Subscriber. | |
SubscriberDatasourceType | Identifies the type of data source that is a non-SQL Server Subscriber. | |
SubscriberLocation | Location of the database as understood by the OLE DB provider for the non-SQL Server Subscriber. | |
SubscriberName | Gets or sets the name of the instance of Microsoft SQL Server that is the Subscriber. (Inherited from Subscription.) | |
SubscriberProvider | Unique programmatic identifier (PROGID) with which the OLE DB provider for the non-SQL Server Subscriber is registered | |
SubscriberProviderString | OLE DB provider-specific connection string is used to connect to the data source for non-SQL Server Subscribers. | |
SubscriberSecurity | Gets the security context used to connect to the Subscriber. (Inherited from Subscription.) | |
SubscriberType | Gets or sets the updating behavior for data changes at the Subscriber. | |
SubscriptionDBName | Gets or sets the name of the database on the Subscriber that receives the replicated data. (Inherited from Subscription.) | |
SubscriptionLSN | ||
SubscriptionType | Gets whether the subscription registration is for a push or pull subscription. (Inherited from Subscription.) | |
SynchronizationAgent | Gets an instance of the TransSynchronizationAgent class that can be used to synchronize the subscription. | |
SynchronizationAgentName | Gets or sets the name of the agent job created to synchronize the subscription. (Inherited from 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. (Inherited from Subscription.) | |
SyncType | Gets or sets the manner in which the subscription is initialized. (Inherited from Subscription.) | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.) |
Top