• Article

ReplicationServer Members

Include Protected Members
Include Inherited 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 ReplicationServer type exposes the following members.

Constructors

  Name Description
Public method ReplicationServer() Initializes a new instance of the ReplicationServer class.
Public method ReplicationServer(ServerConnection) Initializes a new instance of the ReplicationServer class with the specified connection context that is used to establish a connection with the instance of Microsoft SQL Server.

Top

Methods

  Name Description
Public method AttachSubscriptionDatabase(String, String, ConnectionSecurityContext) Attaches a copied subscription database at the Subscriber.
Public method ChangeDistributorPassword(SecureString) Changes the Distributor password, where the new password is supplied as a SecureString object.
Public method ChangeDistributorPassword(String) Changes the Distributor password.
Public method ChangeReplicationServerPasswords(ReplicationSecurityMode, String, SecureString) Changes all stored instances of the password for a login maintained on the replication server using a SecureString object.
Public method ChangeReplicationServerPasswords(ReplicationSecurityMode, String, String) Changes all stored instances of the password for a login maintained on the replication server.
Protected method CheckValidCreation() Infrastructure. (Inherited from ReplicationObject.)
Protected method CheckValidDefinition(Boolean) Infrastructure. (Inherited from ReplicationObject.)
Public method CommitPropertyChanges() Sends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public method CopySubscriptionDatabase(String, String, Boolean) Copies an existing pull subscription database.
Public method Decouple() Decouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public method EnumAgentProfiles(AgentType) Returns the replication agent performance profiles supported on the server.
Public method EnumBusinessLogicHandlers() Returns the business logic handlers registered at the server.
Public method EnumCurrentPrincipals() Returns information for all published databases that are participating in database mirroring.
Public method EnumCustomResolvers() Returns all custom conflict resolvers registered on the connected instance of SQL Server.
Public method EnumDistributionDatabases() Returns the distribution databases installed when the currently connected instance of Microsoft SQL Server is a Distributor.
Public method EnumDistributionPublishers() Returns the Publishers using the currently connected instance of Microsoft SQL Server as their Distributor. 
Public method EnumHeterogeneousColumns(String, String, String) Returns the columns in a table on a non-SQL Server Publisher.
Public method EnumHeterogeneousTables(String) Returns the available tables on a non-SQL Server Publisher.
Public method EnumLightPublications(String, Int32, Boolean, Boolean) Infrastructure.
Public method EnumRegisteredSubscribers() Returns the Subscribers that are registered at a Publisher.
Public method EnumReplicationDatabases() Returns the databases enabled for replication.
Public method EnumSubscriberSubscriptions(String, Int32) Returns the subscriptions on a Subscriber server.
Public method Equals(Object) (Inherited from Object.)
Protected method Finalize() (Inherited from Object.)
Protected method GetChangeCommand(StringBuilder, String, String) Infrastructure. (Inherited from ReplicationObject.)
Protected method GetCreateCommand(StringBuilder, Boolean, ScriptOptions) Infrastructure. (Inherited from ReplicationObject.)
Public method GetCurrentPrincipal(String) Returns the current database mirroring principal for the specified publication database.
Protected method GetDropCommand(StringBuilder, Boolean) Infrastructure. (Inherited from ReplicationObject.)
Public method GetHashCode() (Inherited from Object.)
Public method GetOriginalPublisher(String) Returns the name of the originating Publisher for a published database participating in a database mirroring session.
Public method GetType() (Inherited from Object.)
Public method InstallDistributor(SecureString, DistributionDatabase) Installs a Distributor on the currently connected instance of Microsoft SQL Server, where the password is specified using a SecureString object.
Public method InstallDistributor(String, DistributionDatabase) Installs a Distributor on the currently connected instance of Microsoft SQL Server.
Public method InstallDistributor(String, SecureString) Registers a remote Distributor, where the password is specified using a SecureString object.
Public method InstallDistributor(String, String) Registers a remote Distributor.
Protected method InternalRefresh(Boolean) Infrastructure. (Inherited from ReplicationObject.)
Public method Load() Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public method LoadProperties() Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Protected method MemberwiseClone() (Inherited from Object.)
Public method Refresh() Reloads the properties of the object. (Inherited from ReplicationObject.)
Public method Script(ScriptOptions) Returns a Transact-SQL script to install or uninstall replication on the server.
Public method ScriptInstallDistributor(String, ScriptOptions) Returns a Transact-SQL script that installs the Distributor.
Public method ScriptUninstallDistributor(ScriptOptions) Returns a Transact-SQL script that can be used to uninstall the Distributor.
Public method ToString() (Inherited from Object.)
Public method UninstallDistributor(Boolean) Uninstalls replication publishing and distribution on the currently connected instance of SQL Server. 

Top

Properties

  Name Description
Public property AgentCheckupInterval Gets or sets the interval for the Distribution Agent to perform a checkup.
Public property CachePropertyChanges Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
Public property ConnectionContext Gets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public property DistributionDatabase Gets the name of the distribution database for the currently connected instance of SQL Server. 
Public property DistributionDatabases Gets the distribution databases defined on the replication server.
Public property DistributionPublishers Gets the Publishers that use the currently connected instance of Microsoft SQL Server as a Distributor.
Public property DistributionServer Gets or sets the name of the Distributor for the currently connected instance of SQL Server.
Public property DistributorAvailable Gets whether the Distributor for the currently connected instance of Microsoft SQL Server is currently connected and available or not.
Public property DistributorInstalled Gets whether the currently connected instance of SQL Server has a local or remote Distributor. 
Public property HasRemotePublisher Gets whether or not the currently connected instance of Microsoft SQL Server is a Distributor with a remote Publisher. 
Public property IsDistributor Gets whether the currently connected instance of SQL Server is a Distributor or not.
Public property IsExistingObject Gets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public property IsPublisher Gets whether or not the currently connected instance of Microsoft SQL Server is a Publisher.
Public property Name Gets the name of the instance of Microsoft SQL Server.
Public property RegisteredSubscribers Gets the Subscribers registered with the Publisher.
Public property ReplicationDatabases Gets the databases enabled for replication in the connected instance of Microsoft SQL Server.
Public property SqlServerName Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public property UserData Gets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)
Public property WorkingDirectory Gets the working directory used by a Publisher.

Top