通过

TransArticle Members

  • 项目

Represents an article in a transactional publication.

The following tables list the members exposed by the TransArticle type.

Public Constructors

  名称 Description
TransArticle Overloaded. Creates a new instance of the TransArticle class.

顶部

Public Properties

(see also Protected Properties )

  名称 Description
ms158430.pubproperty(zh-cn,SQL.90).gif ArticleId  Gets the article ID value. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif ArticleLogTablespace Gets or sets the name of the Oracle tablespace used to store replication log information.
ms158430.pubproperty(zh-cn,SQL.90).gif CachePropertyChanges  Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject)
ms158430.pubproperty(zh-cn,SQL.90).gif CommandFormat Gets or sets how changes are propagated for the article.
ms158430.pubproperty(zh-cn,SQL.90).gif ConnectionContext  Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158430.pubproperty(zh-cn,SQL.90).gif CreationScript  Gets or sets the name and full path of the Transact-SQL script file that is used to create the destination object at the Subscriber. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif DatabaseName  Gets or sets the name of the database that contains the data and the objects that are published in the article. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif DatatypeMappingOptions Returns whether the default article data type mapping is used for a non-SQL Server Publisher.
ms158430.pubproperty(zh-cn,SQL.90).gif DeleteCommand Gets or sets the command used to replicate deletes.
ms158430.pubproperty(zh-cn,SQL.90).gif Description  Gets or sets a textual description of the article. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif DestinationObjectName  Gets or sets the database object that is the source database object for the article at the Subscriber. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif DestinationObjectOwner  Gets or sets the schema owner of the source database object for the article at the Subscriber. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif FilterClause Gets or sets the WHERE clause used to filter the article horizontally.
ms158430.pubproperty(zh-cn,SQL.90).gif FilterProcName Gets or sets the stored procedure (created with FOR REPLICATION) used to filter the table horizontally.
ms158430.pubproperty(zh-cn,SQL.90).gif FilterProcOwner Gets or sets the database user who owns the stored procedure that is used to horizontally partition a table-based article.
ms158430.pubproperty(zh-cn,SQL.90).gif IdentityRangeManagementOption  Gets or sets the identity range management options for the article. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif IdentityRangeThreshold  Gets or sets the value at which a new range of identity column values are assigned to a Publisher or to a Subscriber. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif InsertCommand Gets or sets the command used to replicate inserts.
ms158430.pubproperty(zh-cn,SQL.90).gif IsExistingObject  Gets whether the object exists on the server or not. (inherited from ReplicationObject)
ms158430.pubproperty(zh-cn,SQL.90).gif Name  Gets or sets the name of the article. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif PreCreationMethod  Gets or sets the action to take when the published object already exists in the subscription database. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif PublicationName  Gets or sets the name of the publication to which the article belongs. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif PublisherIdentityRangeSize  For a TransArticle object, gets or sets the range of identity values assigned to table columns at the Publisher. For a MergeArticle object, gets or sets the range of identity values assigned to table columns at Subscribers that have server subscriptions. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif PublisherName Gets or sets the name of the non-SQL Server Publisher that publishes the article.
ms158430.pubproperty(zh-cn,SQL.90).gif SchemaOption  Gets or sets the schema creation options for an article. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif SnapshotObjectName Gets or sets the database object that provides the initial data snapshot for the article.
ms158430.pubproperty(zh-cn,SQL.90).gif SnapshotObjectOwner Gets or sets the owner of the database object that provides the initial data snapshot for the article.
ms158430.pubproperty(zh-cn,SQL.90).gif SourceObjectName  Gets or sets the name of the database object that is being published. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif SourceObjectOwner  Gets or sets the owner of the database object that is being published. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif SqlServerName  Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject)
ms158430.pubproperty(zh-cn,SQL.90).gif SubscriberIdentityRangeSize  Gets or sets the maximum number of new rows that can be inserted into an identity column in a table at a Subscriber before another identity range must be allocated. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif Type  Gets or sets the type of article. (inherited from Article)
ms158430.pubproperty(zh-cn,SQL.90).gif UpdateCommand Gets or sets the command used to replicate updates.
ms158430.pubproperty(zh-cn,SQL.90).gif UserData  Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject)
ms158430.pubproperty(zh-cn,SQL.90).gif VerticalPartition  Specifies whether all columns are published in a table article. (inherited from Article)

顶部

Protected Properties

  名称 Description
ms158430.protproperty(zh-cn,SQL.90).gif CreateArticleAsHeterogeneous  (inherited from Article )

顶部

Public Methods

(see also Protected Methods )

  名称 Description
ms158430.pubmethod(zh-cn,SQL.90).gif AddReplicatedColumns Includes columns in a vertically partitioned table article.
ms158430.pubmethod(zh-cn,SQL.90).gif CommitPropertyChanges  Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158430.pubmethod(zh-cn,SQL.90).gif Create  Creates a new article on the currently connected instance of SQL Server based on the current properties of the TransArticle object or the MergeArticle object. (inherited from Article)
ms158430.pubmethod(zh-cn,SQL.90).gif Decouple  Decouples the referenced replication object from the server. (inherited from ReplicationObject)
ms158430.pubmethod(zh-cn,SQL.90).gif EnumHeterogeneousColumns Returns column information for a table article published by a non-SQL Server Publisher.
ms158430.pubmethod(zh-cn,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms158430.pubmethod(zh-cn,SQL.90).gif GetHashCode  (inherited from Object )
ms158430.pubmethod(zh-cn,SQL.90).gif GetType  (inherited from Object )
ms158430.pubmethod(zh-cn,SQL.90).gif ListReplicatedColumns Returns the published columns in a table article.
ms158430.pubmethod(zh-cn,SQL.90).gif Load  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158430.pubmethod(zh-cn,SQL.90).gif LoadProperties  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158430.pubmethod(zh-cn,SQL.90).gifms158430.static(zh-cn,SQL.90).gif ReferenceEquals  (inherited from Object )
ms158430.pubmethod(zh-cn,SQL.90).gif Refresh  Reloads the properties of the object. (inherited from ReplicationObject)
ms158430.pubmethod(zh-cn,SQL.90).gif Remove  Removes an existing article on the currently connected instance of SQL Server based on the current properties of the TransArticle object or the MergeArticle object. (inherited from Article)
ms158430.pubmethod(zh-cn,SQL.90).gif RemoveReplicatedColumns Excludes columns from a vertically partitioned table article.
ms158430.pubmethod(zh-cn,SQL.90).gif Script  (inherited from Article )
ms158430.pubmethod(zh-cn,SQL.90).gif ScriptChangeColumnDestinationDataType Returns a Transact-SQL script used to change the column data type mapping for a non-SQL Server Publisher.
ms158430.pubmethod(zh-cn,SQL.90).gif SetColumnDestinationDataType Sets the column data type mapping for a non-SQL Server Publisher.
ms158430.pubmethod(zh-cn,SQL.90).gif ToString  (inherited from Object )

顶部

Protected Methods

  名称 Description
ms158430.protmethod(zh-cn,SQL.90).gif CheckValidCreation  (inherited from Article )
ms158430.protmethod(zh-cn,SQL.90).gif CheckValidDefinition  (inherited from Article )
ms158430.protmethod(zh-cn,SQL.90).gif Finalize  (inherited from Object )
ms158430.protmethod(zh-cn,SQL.90).gif GetChangeCommand  (inherited from ReplicationObject )
ms158430.protmethod(zh-cn,SQL.90).gif GetCreateCommand  (inherited from ReplicationObject )
ms158430.protmethod(zh-cn,SQL.90).gif GetDropCommand  (inherited from ReplicationObject )
ms158430.protmethod(zh-cn,SQL.90).gif InternalRefresh  (inherited from ReplicationObject )
ms158430.protmethod(zh-cn,SQL.90).gif MemberwiseClone  (inherited from Object )

顶部

请参阅

参考

TransArticle Class
Microsoft.SqlServer.Replication Namespace

其他资源

How to: Define an Article (RMO Programming)