Элементы ReplicationServer
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.
Тип ReplicationServer предоставляет доступ к следующим элементам.
Конструкторы
Имя | Описание | |
---|---|---|
ReplicationServer() () () () | Initializes a new instance of the ReplicationServer class. | |
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. |
В начало
Методы
Имя | Описание | |
---|---|---|
AttachSubscriptionDatabase | Attaches a copied subscription database at the Subscriber. | |
ChangeDistributorPassword(SecureString) | Changes the Distributor password, where the new password is supplied as a SecureString object. | |
ChangeDistributorPassword(String) | Changes the Distributor password. | |
ChangeReplicationServerPasswords(ReplicationSecurityMode, String, SecureString) | Changes all stored instances of the password for a login maintained on the replication server using a SecureString object. | |
ChangeReplicationServerPasswords(ReplicationSecurityMode, String, String) | Changes all stored instances of the password for a login maintained on the replication server. | |
CheckValidCreation | Инфраструктура. (Наследуется из ReplicationObject.) | |
CheckValidDefinition | Инфраструктура. (Наследуется из ReplicationObject.) | |
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (Наследуется из ReplicationObject.) | |
CopySubscriptionDatabase | Copies an existing pull subscription database. | |
Decouple | Decouples the referenced replication object from the server. (Наследуется из 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 | (Наследуется из Object.) | |
Finalize | (Наследуется из Object.) | |
GetChangeCommand | Инфраструктура. (Наследуется из ReplicationObject.) | |
GetCreateCommand | Инфраструктура. (Наследуется из ReplicationObject.) | |
GetCurrentPrincipal | Returns the current database mirroring principal for the specified publication database. | |
GetDropCommand | Инфраструктура. (Наследуется из ReplicationObject.) | |
GetHashCode | (Наследуется из Object.) | |
GetOriginalPublisher | Returns the name of the originating Publisher for a published database participating in a database mirroring session. | |
GetType | (Наследуется из Object.) | |
InstallDistributor(SecureString, DistributionDatabase) | Installs a Distributor on the currently connected instance of Microsoft SQL Server, where the password is specified using a SecureString object. | |
InstallDistributor(String, DistributionDatabase) | Installs a Distributor on the currently connected instance of Microsoft SQL Server. | |
InstallDistributor(String, SecureString) | Registers a remote Distributor, where the password is specified using a SecureString object. | |
InstallDistributor(String, String) | Registers a remote Distributor. | |
InternalRefresh | Инфраструктура. (Наследуется из ReplicationObject.) | |
Load | Loads the properties of an existing object from the server. (Наследуется из ReplicationObject.) | |
LoadProperties | Loads the properties of an existing object from the server. (Наследуется из ReplicationObject.) | |
MemberwiseClone | (Наследуется из Object.) | |
Refresh | Reloads the properties of the object. (Наследуется из ReplicationObject.) | |
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 | (Наследуется из Object.) | |
UninstallDistributor | Uninstalls replication publishing and distribution on the currently connected instance of SQL Server. |
В начало
Свойства
Имя | Описание | |
---|---|---|
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. (Наследуется из ReplicationObject.) | |
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (Наследуется из 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. (Наследуется из 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. (Наследуется из ReplicationObject.) | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (Наследуется из ReplicationObject.) | |
WorkingDirectory | Gets the working directory used by a Publisher. |
В начало