TransArticle Members
Represents an article in a transactional publication.
The following tables list the members exposed by the TransArticle type.
Public Constructors
| Name | Description | |
|---|---|---|
| TransArticle | Overloaded. Creates a new instance of the TransArticle class. |
Top
Public Properties
(see also Protected Properties )
| Name | Description | |
|---|---|---|
.gif "ms158430.pubproperty(en-US,SQL.90).gif") |
ArticleId | Gets the article ID value. (inherited from Article) |
|
ArticleLogTablespace | Gets or sets the name of the Oracle tablespace used to store replication log information. |
|
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject) |
|
CommandFormat | Gets or sets how changes are propagated for the article. |
|
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject) |
|
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) |
|
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) |
|
DatatypeMappingOptions | Returns whether the default article data type mapping is used for a non-SQL Server Publisher. |
|
DeleteCommand | Gets or sets the command used to replicate deletes. |
|
Description | Gets or sets a textual description of the article. (inherited from Article) |
|
DestinationObjectName | Gets or sets the database object that is the source database object for the article at the Subscriber. (inherited from Article) |
|
DestinationObjectOwner | Gets or sets the schema owner of the source database object for the article at the Subscriber. (inherited from Article) |
|
FilterClause | Gets or sets the WHERE clause used to filter the article horizontally. |
|
FilterProcName | Gets or sets the stored procedure (created with FOR REPLICATION) used to filter the table horizontally. |
|
FilterProcOwner | Gets or sets the database user who owns the stored procedure that is used to horizontally partition a table-based article. |
|
IdentityRangeManagementOption | Gets or sets the identity range management options for the article. (inherited from Article) |
|
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) |
|
InsertCommand | Gets or sets the command used to replicate inserts. |
|
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) |
|
Name | Gets or sets the name of the article. (inherited from Article) |
|
PreCreationMethod | Gets or sets the action to take when the published object already exists in the subscription database. (inherited from Article) |
|
PublicationName | Gets or sets the name of the publication to which the article belongs. (inherited from Article) |
|
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) |
|
PublisherName | Gets or sets the name of the non-SQL Server Publisher that publishes the article. |
|
SchemaOption | Gets or sets the schema creation options for an article. (inherited from Article) |
|
SnapshotObjectName | Gets or sets the database object that provides the initial data snapshot for the article. |
|
SnapshotObjectOwner | Gets or sets the owner of the database object that provides the initial data snapshot for the article. |
|
SourceObjectName | Gets or sets the name of the database object that is being published. (inherited from Article) |
|
SourceObjectOwner | Gets or sets the owner of the database object that is being published. (inherited from Article) |
|
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject) |
|
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) |
|
Type | Gets or sets the type of article. (inherited from Article) |
|
UpdateCommand | Gets or sets the command used to replicate updates. |
|
UserData | Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject) |
|
VerticalPartition | Specifies whether all columns are published in a table article. (inherited from Article) |
Top
Protected Properties
| Name | Description | |
|---|---|---|
.gif "ms158430.protproperty(en-US,SQL.90).gif") |
CreateArticleAsHeterogeneous | (inherited from Article ) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms158430.pubmethod(en-US,SQL.90).gif") |
AddReplicatedColumns | Includes columns in a vertically partitioned table article. |
|
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject) |
|
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) |
|
Decouple | Decouples the referenced replication object from the server. (inherited from ReplicationObject) |
|
EnumHeterogeneousColumns | Returns column information for a table article published by a non-SQL Server Publisher. |
|
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
ListReplicatedColumns | Returns the published columns in a table article. |
|
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) |
.gif "ms158430.static(en-US,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Refresh | Reloads the properties of the object. (inherited from ReplicationObject) |
|
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) |
|
RemoveReplicatedColumns | Excludes columns from a vertically partitioned table article. |
|
Script | (inherited from Article ) |
|
ScriptChangeColumnDestinationDataType | Returns a Transact-SQL script used to change the column data type mapping for a non-SQL Server Publisher. |
|
SetColumnDestinationDataType | Sets the column data type mapping for a non-SQL Server Publisher. |
|
ToString | (inherited from Object ) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms158430.protmethod(en-US,SQL.90).gif") |
CheckValidCreation | (inherited from Article ) |
|
CheckValidDefinition | (inherited from Article ) |
|
Finalize | (inherited from Object ) |
|
GetChangeCommand | (inherited from ReplicationObject ) |
|
GetCreateCommand | (inherited from ReplicationObject ) |
|
GetDropCommand | (inherited from ReplicationObject ) |
|
InternalRefresh | (inherited from ReplicationObject ) |
|
MemberwiseClone | (inherited from Object ) |
Top
See Also
Reference
TransArticle Class
Microsoft.SqlServer.Replication Namespace