ReplicationServer Members
Represents an instance of Microsoft SQL Server that is involved in replication. It can take the role of Distributor, Publisher, Subscriber, or any combination of them.
The following tables list the members exposed by the ReplicationServer type.
Public Constructors
Nome | Description | |
---|---|---|
ReplicationServer | Overloaded. Initializes a new instance of the ReplicationServer class. |
Torna all'inizio
Public Properties
Nome | Description | |
---|---|---|
AgentCheckupInterval | Gets or sets the interval for the Distribution Agent to perform a checkup. | |
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) | |
DistributionDatabase | Gets the name of the distribution database for the currently connected instance of SQL Server. | |
DistributionDatabases | Gets the distribution databases defined on the replication server. | |
DistributionPublishers | Gets the Publishers that use the currently connected instance of Microsoft SQL Server as a Distributor. | |
DistributionServer | Gets or sets the name of the Distributor for the currently connected instance of SQL Server. | |
DistributorAvailable | Gets whether the Distributor for the currently connected instance of Microsoft SQL Server is currently connected and available or not. | |
DistributorInstalled | Gets whether the currently connected instance of SQL Server has a local or remote Distributor. | |
HasRemotePublisher | Gets whether or not the currently connected instance of Microsoft SQL Server is a Distributor with a remote Publisher. | |
IsDistributor | Gets whether the currently connected instance of SQL Server is a Distributor or not. | |
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) | |
IsPublisher | Gets whether or not the currently connected instance of Microsoft SQL Server is a Publisher. | |
Name | Gets the name of the instance of Microsoft SQL Server. | |
RegisteredSubscribers | Gets the Subscribers registered with the Publisher. | |
ReplicationDatabases | Gets the databases enabled for replication in the connected instance of Microsoft SQL Server. | |
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject) | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject) | |
WorkingDirectory | Gets the working directory used by a Publisher. |
Torna all'inizio
Public Methods
(see also Protected Methods )
Nome | Description | |
---|---|---|
AttachSubscriptionDatabase | Attaches a copied subscription database at the Subscriber. | |
ChangeDistributorPassword | Overloaded. Changes the Distributor password. | |
ChangeReplicationServerPasswords | Overloaded. Changes all stored instances of the password for a login maintained on the replication server. | |
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject) | |
CopySubscriptionDatabase | Copies an existing pull subscription database. | |
Decouple | Decouples the referenced replication object from the server. (inherited from ReplicationObject) | |
EnumAgentProfiles | Returns the replication agent performance profiles supported on the server. | |
EnumBusinessLogicHandlers | Returns the business logic handlers registered at the server. | |
EnumCurrentPrincipals | Returns information for all published databases that are participating in database mirroring. | |
EnumCustomResolvers | Returns all custom conflict resolvers registered on the connected instance of SQL Server. | |
EnumDistributionDatabases | Returns the distribution databases installed when the currently connected instance of Microsoft SQL Server is a Distributor. | |
EnumDistributionPublishers | Returns the Publishers using the currently connected instance of Microsoft SQL Server as their Distributor. | |
EnumHeterogeneousColumns | Returns the columns in a table on a non-SQL Server Publisher. | |
EnumHeterogeneousTables | Returns the available tables on a non-SQL Server Publisher. | |
EnumLightPublications | ||
EnumRegisteredSubscribers | Returns the Subscribers that are registered at a Publisher. | |
EnumReplicationDatabases | Returns the databases enabled for replication. | |
EnumSubscriberSubscriptions | Returns the subscriptions on a Subscriber server. | |
Equals | Overloaded. (inherited from Object ) | |
GetCurrentPrincipal | Returns the current database mirroring principal for the specified publication database. | |
GetHashCode | (inherited from Object ) | |
GetOriginalPublisher | Returns the name of the originating Publisher for a published database participating in a database mirroring session. | |
GetType | (inherited from Object ) | |
InstallDistributor | Overloaded. Installs a Distributor. | |
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) | |
RegisterBusinessLogicHandler | Registers a business logic handler assembly at the replication server. | |
Script | Returns a Transact-SQL script to install or uninstall replication on the server. | |
ScriptInstallDistributor | Returns a Transact-SQL script that installs the Distributor. | |
ScriptUninstallDistributor | Returns a Transact-SQL script that can be used to uninstall the Distributor. | |
ToString | (inherited from Object ) | |
UninstallDistributor | Uninstalls replication publishing and distribution on the currently connected instance of SQL Server. | |
UnregisterBusinessLogicHandler | Removes the registration for a business logic handler from a replication server. |
Torna all'inizio
Protected Methods
Nome | Description | |
---|---|---|
CheckValidCreation | (inherited from ReplicationObject ) | |
CheckValidDefinition | (inherited from ReplicationObject ) | |
Finalize | (inherited from Object ) | |
GetChangeCommand | (inherited from ReplicationObject ) | |
GetCreateCommand | (inherited from ReplicationObject ) | |
GetDropCommand | (inherited from ReplicationObject ) | |
InternalRefresh | (inherited from ReplicationObject ) | |
MemberwiseClone | (inherited from Object ) |
Torna all'inizio
Vedere anche
Riferimento
ReplicationServer Class
Microsoft.SqlServer.Replication Namespace
Altre risorse
How to: Configure Publishing and Distribution (RMO Programming)
How to: View and Modify Publisher and Distributor Properties (RMO Programming)
How to: Disable Publishing and Distribution (RMO Programming)
Panoramica del modello di pubblicazione della replica