Membri 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.
Il tipo ReplicationServer espone i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
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. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
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 | Infrastruttura. (Ereditato da ReplicationObject). | |
CheckValidDefinition | Infrastruttura. (Ereditato da ReplicationObject). | |
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (Ereditato da ReplicationObject). | |
CopySubscriptionDatabase | Copies an existing pull subscription database. | |
Decouple | Decouples the referenced replication object from the server. (Ereditato da 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 | Infrastruttura. | |
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 | (Ereditato da Object). | |
Finalize | (Ereditato da Object). | |
GetChangeCommand | Infrastruttura. (Ereditato da ReplicationObject). | |
GetCreateCommand | Infrastruttura. (Ereditato da ReplicationObject). | |
GetCurrentPrincipal | Returns the current database mirroring principal for the specified publication database. | |
GetDropCommand | Infrastruttura. (Ereditato da ReplicationObject). | |
GetHashCode | (Ereditato da Object). | |
GetOriginalPublisher | Returns the name of the originating Publisher for a published database participating in a database mirroring session. | |
GetType | (Ereditato da 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 | Infrastruttura. (Ereditato da ReplicationObject). | |
Load | Loads the properties of an existing object from the server. (Ereditato da ReplicationObject). | |
LoadProperties | Loads the properties of an existing object from the server. (Ereditato da ReplicationObject). | |
MemberwiseClone | (Ereditato da Object). | |
Refresh | Reloads the properties of the object. (Ereditato da 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 | (Ereditato da Object). | |
UninstallDistributor | Uninstalls replication publishing and distribution on the currently connected instance of SQL Server. |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
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. (Ereditato da ReplicationObject). | |
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (Ereditato da 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. (Ereditato da 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. (Ereditato da ReplicationObject). | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (Ereditato da ReplicationObject). | |
WorkingDirectory | Gets the working directory used by a Publisher. |
In alto