Freigeben über


Publication-Klasse

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

Vererbungshierarchie

System.Object
  Microsoft.SqlServer.Replication.ReplicationObject
    Microsoft.SqlServer.Replication.Publication
      Microsoft.SqlServer.Replication.MergePublication
      Microsoft.SqlServer.Replication.TransPublication

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

Syntax

'Declaration
<StrongNameIdentityPermissionAttribute(SecurityAction.InheritanceDemand, PublicKey := "0024000004800000940000000602000000240000525341310004000001000100272736ad6e5f9586bac2d531eabc3acc666c2f8ec879fa94f8f7b0327d2ff2ed523448f83c3d5c5dd2dfc7bc99c5286b2c125117bf5cbe242b9d41750732b2bdffe649c6efb8e5526d526fdd130095ecdb7bf210809c6cdad8824faa9ac0310ac3cba2aa0523567b2dfa7fe250b30facbd62d4ec99b94ac47c7d3b28f1f6e4c8",  _
    Name := "Microsoft.SqlServer.Rmo")> _
Public MustInherit Class Publication _
    Inherits ReplicationObject
'Usage
Dim instance As Publication
[StrongNameIdentityPermissionAttribute(SecurityAction.InheritanceDemand, PublicKey = "0024000004800000940000000602000000240000525341310004000001000100272736ad6e5f9586bac2d531eabc3acc666c2f8ec879fa94f8f7b0327d2ff2ed523448f83c3d5c5dd2dfc7bc99c5286b2c125117bf5cbe242b9d41750732b2bdffe649c6efb8e5526d526fdd130095ecdb7bf210809c6cdad8824faa9ac0310ac3cba2aa0523567b2dfa7fe250b30facbd62d4ec99b94ac47c7d3b28f1f6e4c8", 
    Name = "Microsoft.SqlServer.Rmo")]
public abstract class Publication : ReplicationObject
[StrongNameIdentityPermissionAttribute(SecurityAction::InheritanceDemand, PublicKey = L"0024000004800000940000000602000000240000525341310004000001000100272736ad6e5f9586bac2d531eabc3acc666c2f8ec879fa94f8f7b0327d2ff2ed523448f83c3d5c5dd2dfc7bc99c5286b2c125117bf5cbe242b9d41750732b2bdffe649c6efb8e5526d526fdd130095ecdb7bf210809c6cdad8824faa9ac0310ac3cba2aa0523567b2dfa7fe250b30facbd62d4ec99b94ac47c7d3b28f1f6e4c8", 
    Name = L"Microsoft.SqlServer.Rmo")]
public ref class Publication abstract : public ReplicationObject
[<AbstractClassAttribute>]
[<StrongNameIdentityPermissionAttribute(SecurityAction.InheritanceDemand, PublicKey = "0024000004800000940000000602000000240000525341310004000001000100272736ad6e5f9586bac2d531eabc3acc666c2f8ec879fa94f8f7b0327d2ff2ed523448f83c3d5c5dd2dfc7bc99c5286b2c125117bf5cbe242b9d41750732b2bdffe649c6efb8e5526d526fdd130095ecdb7bf210809c6cdad8824faa9ac0310ac3cba2aa0523567b2dfa7fe250b30facbd62d4ec99b94ac47c7d3b28f1f6e4c8", 
    Name = "Microsoft.SqlServer.Rmo")>]
type Publication =  
    class 
        inherit ReplicationObject 
    end
public abstract class Publication extends ReplicationObject

Der Publication-Typ macht folgende Elemente verfügbar.

Konstruktoren

  Name Beschreibung
Geschützte Methode Publication Creates a new instance of the Publication class.

Zum Anfang

Eigenschaften

  Name Beschreibung
Öffentliche Eigenschaft AltSnapshotFolder Gets or sets the alternate snapshot file location for a publication.
Öffentliche Eigenschaft Attributes Gets or sets the publication attributes.
Öffentliche Eigenschaft CachePropertyChanges Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Geerbt von ReplicationObject.)
Öffentliche Eigenschaft CompatibilityLevel Gets or sets the earliest version of Microsoft SQL Server running on the Subscribers that the referenced publication can support.
Öffentliche Eigenschaft ConflictRetention Gets or sets the number of days that conflict data rows are retained in conflict tables.
Öffentliche Eigenschaft ConnectionContext Gets or sets the connection to an instance of Microsoft SQL Server. (Geerbt von ReplicationObject.)
Öffentliche Eigenschaft CreateSnapshotAgentByDefault Gets or sets if the Snapshot Agent job is added automatically when the publication is created.
Öffentliche Eigenschaft DatabaseName Gets or sets the name of the publication database.
Öffentliche Eigenschaft Description Gets or sets a textual description of the publication.
Öffentliche Eigenschaft FtpAddress Gets or sets the address of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft FtpPort Gets or sets the port of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
Öffentliche Eigenschaft FtpSubdirectory Gets or sets the subdirectory on the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
Öffentliche Eigenschaft HasSubscription Gets whether the publication has one or more subscriptions.
Öffentliche Eigenschaft IsExistingObject Gets whether the object exists on the server or not. (Geerbt von ReplicationObject.)
Öffentliche Eigenschaft Name Gets or sets the name of the publication.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft PubId Gets the value that uniquely identifies the publication.
Öffentliche Eigenschaft ReplicateDdl Gets or sets the data definition language (DDL) replication options that determine if DDL changes are replicated.
Öffentliche Eigenschaft RetentionPeriod Gets or sets the amount of time before a subscription expires when the subscription is not synchronized with the publication.
Öffentliche Eigenschaft 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.
Öffentliche Eigenschaft SnapshotAgentExists Gets if the SQL Server Agent job exists to generate the initial snapshot for this publication.
Öffentliche Eigenschaft SnapshotGenerationAgentProcessSecurity Gets an object that sets the Windows account under which the Snapshot Agent job runs.
Öffentliche Eigenschaft SnapshotGenerationAgentPublisherSecurity Gets the security context used by the Snapshot Agent to connect to the Publisher.
Öffentliche Eigenschaft SnapshotJobId Gets the Snapshot Agent job ID for the current publication.
Öffentliche Eigenschaft SnapshotMethod Gets or sets the data file format of the initial snapshot.
Öffentliche Eigenschaft SnapshotSchedule Gets an object that sets the schedule for the Snapshot Agent for the current publication.
Öffentliche Eigenschaft SqlServerName Gets the name of the Microsoft SQL Server instance to which this object is connected. (Geerbt von ReplicationObject.)
Öffentliche Eigenschaft Status Gets or sets the status of the publication.
Öffentliche Eigenschaft Type Gets or sets the type of publication.
Öffentliche Eigenschaft UserData Gets or sets an object property that allows users to attach their own data to the object. (Geerbt von ReplicationObject.)

Zum Anfang

Methoden

  Name Beschreibung
Geschützte Methode CheckValidCreation Infrastruktur Checks the valid replication creation. (Geerbt von ReplicationObject.)
Geschützte Methode CheckValidDefinition Infrastruktur Indicates whether to check valid definition. (Überschreibt ReplicationObject.CheckValidDefinition(Boolean).)
Öffentliche Methode CommitPropertyChanges Sends all the cached property change statements to the instance of Microsoft SQL Server. (Geerbt von ReplicationObject.)
Öffentliche Methode Create Creates the publication.
Öffentliche Methode 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.
Öffentliche Methode Decouple Decouples the referenced replication object from the server. (Geerbt von ReplicationObject.)
Öffentliche Methode EnumArticles Returns the articles in the publication.
Öffentliche Methode EnumPublicationAccesses Returns logins that have access to the Publisher.
Öffentliche Methode EnumSubscriptions Returns the subscriptions that subscribe to the publication.
Öffentliche Methode Equals (Geerbt von Object.)
Geschützte Methode Finalize (Geerbt von Object.)
Geschützte Methode GetChangeCommand Infrastruktur Returns the change command from the replication. (Geerbt von ReplicationObject.)
Geschützte Methode GetCreateCommand Infrastruktur Returns the create command from the replication. (Geerbt von ReplicationObject.)
Geschützte Methode GetDropCommand Infrastruktur Returns the drop command from the replication. (Geerbt von ReplicationObject.)
Öffentliche Methode GetHashCode (Geerbt von Object.)
Öffentliche Methode GetType (Geerbt von Object.)
Öffentliche Methode GrantPublicationAccess Adds the specified login to the publication access list (PAL).
Geschützte Methode InternalRefresh Infrastruktur Initiates an internal refresh from the replication. (Geerbt von ReplicationObject.)
Öffentliche Methode Load Loads the properties of an existing object from the server. (Geerbt von ReplicationObject.)
Öffentliche Methode LoadProperties Loads the properties of an existing object from the server. (Geerbt von ReplicationObject.)
Geschützte Methode MemberwiseClone (Geerbt von Object.)
Öffentliche Methode Refresh Reloads the properties of the object. (Geerbt von ReplicationObject.)
Öffentliche Methode Remove() Removes an existing publication.
Öffentliche Methode Remove(Boolean) Removes an existing publication even if the Distributor cannot be accessed.
Öffentliche Methode ReplicateUserDefinedScript Replicates the execution of a user-defined script to the Subscribers of a specified publication.
Öffentliche Methode RevokePublicationAccess Removes the specified login from the publication access list (PAL).
Öffentliche Methode Script Generates a Transact-SQL script that can be used to re-create the publication as specified by the script options.
Öffentliche Methode StartSnapshotGenerationAgentJob Starts the job that generates the initial snapshot for the publication.
Öffentliche Methode StopSnapshotGenerationAgentJob Attempts to stop a running Snapshot Agent job.
Öffentliche Methode ToString (Geerbt von Object.)

Zum Anfang

Hinweise

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 Verschlüsseln von Verbindungen zu SQL Server.

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.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Replication-Namespace