.png)
Publication Members
The Publication class is a base class from which the TransPublication class and the MergePublication class are derived.
The Publication type exposes the following members.
| Name | Description | |
|---|---|---|
|
CheckValidCreation() | Infrastructure. (Inherited from ReplicationObject.) |
|
|
CheckValidDefinition(Boolean) | Infrastructure. (Overrides ReplicationObject.CheckValidDefinition(Boolean).) |
|
|
CommitPropertyChanges() | Sends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.) |
|
|
Create() | Creates the 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. |
|
|
Decouple() | Decouples the referenced replication object from the server. (Inherited from ReplicationObject.) |
|
|
EnumArticles() | Returns the articles in the publication. |
|
|
EnumPublicationAccesses(Boolean) | Returns logins that have access to the Publisher. |
|
|
EnumSubscriptions() | Returns the subscriptions that subscribe to the publication. |
|
|
Equals(Object) | (Inherited from Object.) |
|
|
Finalize() | (Inherited from Object.) |
|
|
GetChangeCommand(StringBuilder, String, String) | Infrastructure. (Inherited from ReplicationObject.) |
|
|
GetCreateCommand(StringBuilder, Boolean, ScriptOptions) | Infrastructure. (Inherited from ReplicationObject.) |
|
|
GetDropCommand(StringBuilder, Boolean) | Infrastructure. (Inherited from ReplicationObject.) |
|
|
GetHashCode() | (Inherited from Object.) |
|
|
GetType() | (Inherited from Object.) |
|
|
GrantPublicationAccess(String) | Adds the specified login to the publication access list (PAL). |
|
|
InternalRefresh(Boolean) | Infrastructure. (Inherited from ReplicationObject.) |
|
|
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.) |
|
|
MemberwiseClone() | (Inherited from Object.) |
|
|
Refresh() | Reloads the properties of the object. (Inherited from ReplicationObject.) |
|
|
Remove() | Removes an existing publication. |
|
|
Remove(Boolean) | Removes an existing publication even if the Distributor cannot be accessed. |
|
|
ReplicateUserDefinedScript(String) | Replicates the execution of a user-defined script to the Subscribers of a specified publication. |
|
|
RevokePublicationAccess(String) | Removes the specified login from the publication access list (PAL). |
|
|
Script(ScriptOptions) | Generates a Transact-SQL script that can be used to re-create the publication as specified by the script options. |
|
|
StartSnapshotGenerationAgentJob() | Starts the job that generates the initial snapshot for the publication. |
|
|
StopSnapshotGenerationAgentJob() | Attempts to stop a running Snapshot Agent job. |
|
|
ToString() | (Inherited from Object.) |
| Name | Description | |
|---|---|---|
|
|
AltSnapshotFolder | Gets or sets the alternate snapshot file location for a publication. |
|
|
Attributes | Gets or sets the publication attributes. |
|
|
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.) |
|
|
CompatibilityLevel | Gets or sets the earliest version of Microsoft SQL Server running on the Subscribers that the referenced publication can support. |
|
|
ConflictRetention | Gets or sets the number of days that conflict data rows are retained in conflict tables. |
|
|
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.) |
|
|
CreateSnapshotAgentByDefault | Gets or sets if the Snapshot Agent job is added automatically when the publication is created. |
|
|
DatabaseName | Gets or sets the name of the publication database. |
|
|
Description | Gets or sets a textual description of the publication. |
|
|
FtpAddress | Gets or sets the address of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. |
|
|
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. |
|
|
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. |
|
|
FtpPort | Gets or sets the port of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. |
|
|
FtpSubdirectory | Gets or sets the subdirectory on the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. |
|
|
HasSubscription | Gets whether the publication has one or more subscriptions. |
|
|
IsExistingObject | Gets whether the object exists on the server or not. (Inherited from ReplicationObject.) |
|
|
Name | Gets or sets the name of the publication. |
|
|
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. |
|
|
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. |
|
|
PubId | Gets the value that uniquely identifies the publication. |
|
|
ReplicateDdl | Gets or sets the data definition language (DDL) replication options that determine if DDL changes are replicated. |
|
|
RetentionPeriod | Gets or sets the amount of time before a subscription expires when the subscription is not synchronized with the 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. |
|
|
SnapshotAgentExists | Gets if the SQL Server Agent job exists to generate the initial snapshot for this publication. |
|
|
SnapshotGenerationAgentProcessSecurity | Gets an object that sets the Windows account under which the Snapshot Agent job runs. |
|
|
SnapshotGenerationAgentPublisherSecurity | Gets the security context used by the Snapshot Agent to connect to the Publisher. |
|
|
SnapshotJobId | Gets the Snapshot Agent job ID for the current publication. |
|
|
SnapshotMethod | Gets or sets the data file format of the initial snapshot. |
|
|
SnapshotSchedule | Gets an object that sets the schedule for the Snapshot Agent for the current publication. |
|
|
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.) |
|
|
Status | Gets or sets the status of the publication. |
|
|
Type | Gets or sets the type of publication. |
|
|
UserData | Gets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.) |
