Export (0) Print
Expand All

Publication Class

The Publication class is a base class from which the TransPublication class and the MergePublication class are derived.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

[StrongNameIdentityPermissionAttribute(SecurityAction::InheritanceDemand, PublicKey = L"0024000004800000940000000602000000240000525341310004000001000100272736ad6e5f9586bac2d531eabc3acc666c2f8ec879fa94f8f7b0327d2ff2ed523448f83c3d5c5dd2dfc7bc99c5286b2c125117bf5cbe242b9d41750732b2bdffe649c6efb8e5526d526fdd130095ecdb7bf210809c6cdad8824faa9ac0310ac3cba2aa0523567b2dfa7fe250b30facbd62d4ec99b94ac47c7d3b28f1f6e4c8", 
	Name = L"Microsoft.SqlServer.Rmo")]
public ref class Publication abstract : public ReplicationObject

The Publication type exposes the following members.

  NameDescription
Protected methodPublicationCreates a new instance of the Publication class.
Top

  NameDescription
Public propertyAltSnapshotFolderGets or sets the alternate snapshot file location for a publication.
Public propertyAttributesGets or sets the publication attributes.
Public propertyCachePropertyChangesGets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
Public propertyCompatibilityLevelGets or sets the earliest version of Microsoft SQL Server running on the Subscribers that the referenced publication can support.
Public propertyConflictRetentionGets or sets the number of days that conflict data rows are retained in conflict tables.
Public propertyConnectionContextGets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public propertyCreateSnapshotAgentByDefaultGets or sets if the Snapshot Agent job is added automatically when the publication is created.
Public propertyDatabaseNameGets or sets the name of the publication database.
Public propertyDescriptionGets or sets a textual description of the publication.
Public propertyFtpAddressGets or sets the address of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
Public propertyFtpLoginGets or sets the login that is used to connect to the File Transfer Protocol (FTP) server for publications that allow subscription initialization over FTP.
Public propertyFtpPasswordSets 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.
Public propertyFtpPortGets or sets the port of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
Public propertyFtpSubdirectoryGets or sets the subdirectory on the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
Public propertyHasSubscriptionGets whether the publication has one or more subscriptions.
Public propertyIsExistingObjectGets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public propertyNameGets or sets the name of the publication.
Public propertyPostSnapshotScriptGets 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.
Public propertyPreSnapshotScriptGets 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.
Public propertyPubIdGets the value that uniquely identifies the publication.
Public propertyReplicateDdlGets or sets the data definition language (DDL) replication options that determine if DDL changes are replicated.
Public propertyRetentionPeriodGets or sets the amount of time before a subscription expires when the subscription is not synchronized with the publication.
Public propertySecureFtpPasswordSets 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.
Public propertySnapshotAgentExistsGets if the SQL Server Agent job exists to generate the initial snapshot for this publication.
Public propertySnapshotGenerationAgentProcessSecurityGets an object that sets the Windows account under which the Snapshot Agent job runs.
Public propertySnapshotGenerationAgentPublisherSecurityGets the security context used by the Snapshot Agent to connect to the Publisher.
Public propertySnapshotJobIdGets the Snapshot Agent job ID for the current publication.
Public propertySnapshotMethodGets or sets the data file format of the initial snapshot.
Public propertySnapshotScheduleGets an object that sets the schedule for the Snapshot Agent for the current publication.
Public propertySqlServerNameGets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public propertyStatusGets or sets the status of the publication.
Public propertyTypeGets or sets the type of publication.
Public propertyUserDataGets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)
Top

  NameDescription
Protected methodCheckValidCreationInfrastructure. Checks the valid replication creation. (Inherited from ReplicationObject.)
Protected methodCheckValidDefinitionInfrastructure. Indicates whether to check valid definition. (Overrides ReplicationObject::CheckValidDefinition(Boolean).)
Public methodCommitPropertyChangesSends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public methodCreateCreates the publication.
Public methodCreateSnapshotAgentCreates the SQL Server Agent job that is used to generate the initial snapshot for the publication, if this job does not already exist.
Public methodDecoupleDecouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public methodEnumArticlesReturns the articles in the publication.
Public methodEnumPublicationAccessesReturns logins that have access to the Publisher.
Public methodEnumSubscriptionsReturns the subscriptions that subscribe to the publication.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Protected methodGetChangeCommandInfrastructure. Returns the change command from the replication. (Inherited from ReplicationObject.)
Protected methodGetCreateCommandInfrastructure. Returns the create command from the replication. (Inherited from ReplicationObject.)
Protected methodGetDropCommandInfrastructure. Returns the drop command from the replication. (Inherited from ReplicationObject.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodGrantPublicationAccessAdds the specified login to the publication access list (PAL).
Protected methodInternalRefreshInfrastructure. Initiates an internal refresh from the replication. (Inherited from ReplicationObject.)
Public methodLoadLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public methodLoadPropertiesLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRefreshReloads the properties of the object. (Inherited from ReplicationObject.)
Public methodRemove()Removes an existing publication.
Public methodRemove(Boolean)Removes an existing publication even if the Distributor cannot be accessed.
Public methodReplicateUserDefinedScriptReplicates the execution of a user-defined script to the Subscribers of a specified publication.
Public methodRevokePublicationAccessRemoves the specified login from the publication access list (PAL).
Public methodScriptGenerates a Transact-SQL script that can be used to re-create the publication as specified by the script options.
Public methodStartSnapshotGenerationAgentJobStarts the job that generates the initial snapshot for the publication.
Public methodStopSnapshotGenerationAgentJobAttempts to stop a running Snapshot Agent job.
Public methodToString (Inherited from Object.)
Top

When configuring a Publisher with a remote Distributor, the values supplied for all properties, including SnapshotGenerationAgentProcessSecurity, are sent to the Distributor as plain text. You should encrypt the connection between the Publisher and its remote Distributor before calling the Create or the CreateSnapshotAgent methods. For more information, see sp_changemergepublication (Transact-SQL).

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft