MergeArticle Members
Represents an article in a merge publication.
The following tables list the members exposed by the MergeArticle type.
Name | Description | |
---|---|---|
MergeArticle | Overloaded. Creates a new instance of the MergeArticle class. |
Top
(see also Protected Properties )
Name | Description | |
---|---|---|
AllowInteractiveResolver | Gets or sets whether to allow subscriptions to invoke an interactive resolver when conflicts occur during synchronization. | |
ArticleId | Gets the article ID value. (inherited from Article) | |
ArticleResolver | Gets or sets the friendly name of the custom conflict resolver or business logic handler used when synchronizing the article. | |
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject) | |
CheckPermissions | Gets or sets how the permissions are checked at the Publisher before changes are uploaded from a Subscriber. | |
ColumnTracking | Gets or sets how conflicts are detected when synchronizing data rows. | |
CompensateForErrors | Gets or sets whether compensating actions are taken when errors are encountered during synchronization. | |
ConflictTable | Gets the name of the table used to track conflicts that occur when synchronizing a merge 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) | |
DeleteTracking | Gets or sets whether deletes are replicated. | |
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 (Transact-SQL) clause that is evaluated to filter an article horizontally. | |
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) | |
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) | |
MultipleColumnUpdate | ||
Name | Gets or sets the name of the article. (inherited from Article) | |
PartitionOption | Gets or sets the filtering options when an article is filtered using a parameterized row filter. | |
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) | |
ResolverInfo | Gets or sets additional data and parameters that are to be used by a COM-based conflict resolver. | |
SchemaOption | Gets or sets the schema creation options for an article. (inherited from Article) | |
SnapshotObjectName | Gets the name of the database object that represents the initial snapshot data for the article. | |
SnapshotObjectOwner | Gets the owner of the database object that represents the initial snapshot data 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) | |
Status | Gets or sets the status of the merge article. | |
StreamBlobColumns | Gets or sets whether a data stream optimization is used when replicating binary large object (BLOB) columns. | |
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) | |
SubscriberUploadOption | Gets or sets the behavior of updates made at a Subscriber with a client subscription. | |
Type | Gets or sets the type of article. (inherited from Article) | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject) | |
VerifyResolverSignature | Gets or sets the options for verifying the digital signature on a COM-based conflict resolver to determine if it is from a trusted source. | |
VerticalPartition | Specifies whether all columns are published in a table article. (inherited from Article) |
Top
Name | Description | |
---|---|---|
CreateArticleAsHeterogeneous | (inherited from Article ) |
Top
(see also Protected Methods )
Name | Description | |
---|---|---|
AddMergeJoinFilter | Adds a join filter to the merge article. | |
AddReplicatedColumns | Adds the specified columns to the merge article. | |
ChangeMergeJoinFilter | Changes a join filter that defined on a merge 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) | |
EnumMergeJoinFilters | Returns the join filters that are defined for the merge article. | |
Equals | Overloaded. (inherited from Object ) | |
GetHashCode | (inherited from Object ) | |
GetType | (inherited from Object ) | |
InitializeSharedPropertiesBasedOnExistingArticles | ||
ListReplicatedColumns | Returns the columns that exist in a vertically partitioned 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) | |
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) | |
RemoveMergeJoinFilter | Removes the specified merge join filter from the article. | |
RemoveReplicatedColumns | Removes existing columns from a vertically partitioned article. | |
Script | (inherited from Article ) | |
ScriptMergeJoinFilter | Returns a Transact-SQL script of the merge join filter attached to the merge article. | |
ToString | (inherited from Object ) |
Top
Name | Description | |
---|---|---|
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
MergeArticle Class
Microsoft.SqlServer.Replication Namespace
How to: Define an Article (RMO Programming)
Publishing Data and Database Objects