Membres TransPublication
Represents a transactional publication.
Le type TransPublication expose les membres suivants.
Constructeurs
Nom | Description | |
---|---|---|
TransPublication() () () () | Creates a new instance of the TransPublication class. | |
TransPublication(String, String, ServerConnection) | Creates a new instance of the TransPublication class with the required properties. | |
TransPublication(String, String, ServerConnection, Boolean) | Creates a new instance of the TransPublication class with the required properties, and indicates whether the Snapshot Agent job for the publication is created. |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
BrowseSnapshotFolder | Returns the complete path of the location where snapshot files were generated for a specific subscription. | |
CheckValidCreation | Infrastructure. (Hérité de ReplicationObject.) | |
CheckValidDefinition | Infrastructure. (Hérité de Publication.) | |
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (Hérité de ReplicationObject.) | |
CopySnapshot | Copies the latest snapshot files for a specific subscription to a destination folder. | |
Create | Creates the publication. (Hérité de Publication.) | |
CreateSnapshotAgent | Creates the SQL Server Agent job that is used to generate the initial snapshot for the publication, if this job does not already exist. (Hérité de Publication.) | |
Decouple | Decouples the referenced replication object from the server. (Hérité de ReplicationObject.) | |
EnumArticles | Returns the articles in the publication. (Hérité de Publication.) | |
EnumPublicationAccesses | Returns logins that have access to the Publisher. (Hérité de Publication.) | |
EnumSubscriptions | Returns the subscriptions that subscribe to the publication. (Hérité de Publication.) | |
Equals | (Hérité de Object.) | |
Finalize | (Hérité de Object.) | |
GetChangeCommand | Infrastructure. (Hérité de ReplicationObject.) | |
GetCreateCommand | Infrastructure. (Hérité de ReplicationObject.) | |
GetDropCommand | Infrastructure. (Hérité de ReplicationObject.) | |
GetHashCode | (Hérité de Object.) | |
GetType | (Hérité de Object.) | |
GrantPublicationAccess | Adds the specified login to the publication access list (PAL). (Hérité de Publication.) | |
InternalRefresh | Infrastructure. (Hérité de ReplicationObject.) | |
Load | Loads the properties of an existing object from the server. (Hérité de ReplicationObject.) | |
LoadProperties | Loads the properties of an existing object from the server. (Hérité de ReplicationObject.) | |
MakePullSubscriptionWellKnown | Registers a pull subscription at the Publisher. | |
MemberwiseClone | (Hérité de Object.) | |
PostTracerToken | Posts a tracer token into the Publisher log to begin the process of determining latency. | |
Refresh | Reloads the properties of the object. (Hérité de ReplicationObject.) | |
RefreshSubscriptions | Updates all subscriptions to a publication to include any newly added articles. | |
ReinitializeAllSubscriptions() () () () | Marks all subscriptions to the publication for reinitialization. | |
ReinitializeAllSubscriptions(Boolean) | Marks all subscriptions to the publication for reinitialization, with the option to invalidate an existing snapshot. | |
Remove() () () () | Removes an existing publication. (Hérité de Publication.) | |
Remove(Boolean) | Removes an existing publication even if the Distributor cannot be accessed. (Hérité de Publication.) | |
RemovePullSubscription | Removes the registration for a pull subscription at the Publisher. | |
ReplicateUserDefinedScript | Replicates the execution of a user-defined script to the Subscribers of a specified publication. (Hérité de Publication.) | |
RevokePublicationAccess | Removes the specified login from the publication access list (PAL). (Hérité de Publication.) | |
Script | Generates a Transact-SQL script that can be used to re-create the publication as specified by the script options. (Hérité de Publication.) | |
SetPeerConflictDetection | Enables or disables conflict detection for a node in a peer-to-peer topology. | |
StartSnapshotGenerationAgentJob | Starts the job that generates the initial snapshot for the publication. (Hérité de Publication.) | |
StopSnapshotGenerationAgentJob | Attempts to stop a running Snapshot Agent job. (Hérité de Publication.) | |
ToString | (Hérité de Object.) | |
ValidatePublication | Invokes inline publication validation for all subscriptions. | |
ValidateSubscriptions | Invokes inline publication validation for the specified subscription. |
Haut de la page
Propriétés
Nom | Description | |
---|---|---|
AltSnapshotFolder | Gets or sets the alternate snapshot file location for a publication. (Hérité de Publication.) | |
Attributes | Gets or sets the publication attributes. (Hérité de Publication.) | |
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Hérité de ReplicationObject.) | |
CompatibilityLevel | Gets or sets the earliest version of Microsoft SQL Server running on the Subscribers that the referenced publication can support. (Hérité de Publication.) | |
ConflictPolicy | Gets or sets the conflict policy for publications that support updating subscriptions. | |
ConflictRetention | Gets or sets the number of days that conflict data rows are retained in conflict tables. (Hérité de Publication.) | |
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (Hérité de ReplicationObject.) | |
ContinueOnConflict | Determines whether the Distribution Agent continues to process changes after a conflict is detected. | |
CreateSnapshotAgentByDefault | Gets or sets if the Snapshot Agent job is added automatically when the publication is created. (Hérité de Publication.) | |
DatabaseName | Gets or sets the name of the publication database. (Hérité de Publication.) | |
Description | Gets or sets a textual description of the publication. (Hérité de Publication.) | |
FtpAddress | Gets or sets the address of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. (Hérité de Publication.) | |
FtpLogin | Gets or sets the login that is used to connect to the File Transfer Protocol (FTP) server for publications that allow subscription initialization over FTP. (Hérité de Publication.) | |
FtpPassword | Sets the password for the login that is used to connect to the File Transfer Protocol (FTP) server for publications that allow subscription initialization over FTP. (Hérité de Publication.) | |
FtpPort | Gets or sets the port of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. (Hérité de Publication.) | |
FtpSubdirectory | Gets or sets the subdirectory on the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. (Hérité de Publication.) | |
HasSubscription | Gets whether the publication has one or more subscriptions. (Hérité de Publication.) | |
IsExistingObject | Gets whether the object exists on the server or not. (Hérité de ReplicationObject.) | |
Name | Gets or sets the name of the publication. (Hérité de Publication.) | |
PeerConflictDetectionEnabled | Gets whether peer-to-peer conflict detection was enabled by using SetPeerConflictDetection. | |
PeerOriginatorID | Gets the ID for a node in a peer-to-peer topology; this ID is used for conflict detection if PeerConflictDetectionEnabled is set to true. | |
PostSnapshotScript | Gets or sets the name and full path of a Transact-SQL script file that is executed after the initial snapshot is applied to the Subscriber. (Hérité de Publication.) | |
PreSnapshotScript | Gets or sets the name and full path of a Transact-SQL script file that is executed before the initial snapshot is applied to the Subscriber. (Hérité de Publication.) | |
PubId | Gets the value that uniquely identifies the publication. (Hérité de Publication.) | |
PublisherName | Gets or sets the name of the non-SQL Server Publisher. | |
QueueType | Gets or sets the type of queue to use for publications that allow queued updating subscriptions. | |
ReplicateDdl | Gets or sets the data definition language (DDL) replication options that determine if DDL changes are replicated. (Hérité de Publication.) | |
RetentionPeriod | Gets or sets the amount of time before a subscription expires when the subscription is not synchronized with the publication. (Hérité de Publication.) | |
SecureFtpPassword | Sets the password (as a SecureString object) for the login used to connect to the File Transfer Protocol (FTP) server for publications that allow subscription initialization over FTP. (Hérité de Publication.) | |
SnapshotAgentExists | Gets if the SQL Server Agent job exists to generate the initial snapshot for this publication. (Hérité de Publication.) | |
SnapshotAvailable | Gets whether or not the snapshot files for this publication are available for use. | |
SnapshotGenerationAgentProcessSecurity | Gets an object that sets the Windows account under which the Snapshot Agent job runs. (Hérité de Publication.) | |
SnapshotGenerationAgentPublisherSecurity | Gets the security context used by the Snapshot Agent to connect to the Publisher. (Hérité de Publication.) | |
SnapshotJobId | Gets the Snapshot Agent job ID for the current publication. (Hérité de Publication.) | |
SnapshotMethod | Gets or sets the data file format of the initial snapshot. (Hérité de Publication.) | |
SnapshotSchedule | Gets an object that sets the schedule for the Snapshot Agent for the current publication. (Hérité de Publication.) | |
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (Hérité de ReplicationObject.) | |
Status | Gets or sets the status of the publication. (Hérité de Publication.) | |
TransArticles | Represents the articles in the publication. | |
TransSubscriptions | Represents subscriptions to the publication. | |
Type | Gets or sets the type of publication. (Hérité de Publication.) | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (Hérité de ReplicationObject.) |
Haut de la page