Элементы MergePublication
Represents a merge publication.
Тип MergePublication предоставляет доступ к следующим элементам.
Конструкторы
Имя | Описание | |
---|---|---|
MergePublication() () () () | Creates a new instance of the MergePublication class. | |
MergePublication(String, String, ServerConnection) | Initializes a new instance of the MergePublication class with the specified name, database, and connection to the Publisher. | |
MergePublication(String, String, ServerConnection, Boolean) | Creates an instance of the MergePublication class, specifying whether the Snapshot Agent job should be created by default. |
В начало
Методы
Имя | Описание | |
---|---|---|
AddMergeDynamicSnapshotJob | Adds a Snapshot Agent job that generates the filtered data partition for a Subscriber when a parameterized row filter is used. | |
AddMergeDynamicSnapshotJobForLateBoundComClients | Enables late-bound COM clients to add a Snapshot Agent job that generates the filtered data partition for a Subscriber when a parameterized row filter is used. | |
AddMergePartition | Defines a Subscriber partition for a merge publication with a parameterized row filter. | |
BrowseSnapshotFolder | Returns the complete path of the directory location where snapshot files are generated. | |
ChangeMergeDynamicSnapshotJobScheduleWithJobId | Modifies the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber, based on the job ID. | |
ChangeMergeDynamicSnapshotJobScheduleWithJobIdForLateBoundComClients | Allows late-bound COM clients to modify the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber, based on the job ID. | |
ChangeMergeDynamicSnapshotJobScheduleWithJobName | Modifies the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber, based on the job name. | |
ChangeMergeDynamicSnapshotJobScheduleWithJobNameForLateBoundComClients | Allows late-bound COM clients to modify the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber, based on the job name. | |
CheckValidCreation | Инфраструктура. (Наследуется из ReplicationObject.) | |
CheckValidDefinition | Инфраструктура. (Наследуется из Publication.) | |
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (Наследуется из ReplicationObject.) | |
CopySnapshot | Copies the snapshot files for the merge publication from the snapshot folder to a destination folder. | |
Create | Creates the publication. (Наследуется из Publication.) | |
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. (Наследуется из Publication.) | |
Decouple | Decouples the referenced replication object from the server. (Наследуется из ReplicationObject.) | |
DisableSynchronizationPartner | Disables the specified synchronization partner for this merge publication. | |
EnableSynchronizationPartner | Enables a specified synchronization partner for this merge publication. | |
EnumAllMergeJoinFilters | Returns all the merge join filters defined on the merge publication. | |
EnumArticles | Returns the articles in the publication. (Наследуется из Publication.) | |
EnumMergeDynamicSnapshotJobs | Returns a list of merge dynamic snapshot jobs. | |
EnumMergePartitions | Returns the Subscriber partitions defined for this merge publication. | |
EnumPublicationAccesses | Returns logins that have access to the Publisher. (Наследуется из Publication.) | |
EnumSubscriptions | Returns the subscriptions that subscribe to the publication. (Наследуется из Publication.) | |
EnumSynchronizationPartners | Returns the alternate synchronization partners for this merge publication. | |
Equals | (Наследуется из Object.) | |
Finalize | (Наследуется из Object.) | |
GenerateFilters | Инфраструктура. | |
GetChangeCommand | Инфраструктура. (Наследуется из ReplicationObject.) | |
GetCreateCommand | Инфраструктура. (Наследуется из ReplicationObject.) | |
GetDropCommand | Инфраструктура. (Наследуется из ReplicationObject.) | |
GetHashCode | (Наследуется из Object.) | |
GetMergeDynamicSnapshotJobScheduleWithJobId | Returns the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber based on the job ID. | |
GetMergeDynamicSnapshotJobScheduleWithJobName | Returns the schedule for the Snapshot Agent job that generates the filtered data partition for a Subscriber based on the job name. | |
GetType | (Наследуется из Object.) | |
GrantPublicationAccess | Adds the specified login to the publication access list (PAL). (Наследуется из Publication.) | |
InternalRefresh | Инфраструктура. (Наследуется из ReplicationObject.) | |
Load | Loads the properties of an existing object from the server. (Наследуется из ReplicationObject.) | |
LoadProperties | Loads the properties of an existing object from the server. (Наследуется из ReplicationObject.) | |
MakePullSubscriptionWellKnown | Registers a merge pull subscription at the Publisher. | |
MemberwiseClone | (Наследуется из Object.) | |
ReadLastValidationDateTimes | Returns information about the most recent subscription validation for a Subscriber. | |
Refresh | Reloads the properties of the object. (Наследуется из ReplicationObject.) | |
ReinitializeAllSubscriptions | Marks all the subscriptions for reinitialization. | |
Remove() () () () | Removes an existing publication. (Наследуется из Publication.) | |
Remove(Boolean) | Removes an existing publication even if the Distributor cannot be accessed. (Наследуется из Publication.) | |
RemoveMergeDynamicSnapshotJob | Removes the specified dynamic snapshot job from the merge publication. | |
RemoveMergePartition | Removes an existing Subscriber partition defined on the merge publication. | |
RemovePullSubscription | Removes the registration of a Subscriber with a pull subscription to the merge publication. | |
ReplicateUserDefinedScript | Replicates the execution of a user-defined script to the Subscribers of a specified publication. (Наследуется из Publication.) | |
ResynchronizeSubscription | Resynchronizes a merge subscription to a known validation state that you specify. | |
RevokePublicationAccess | Removes the specified login from the publication access list (PAL). (Наследуется из Publication.) | |
Script | Generates a Transact-SQL script that can be used to re-create the publication as specified by the script options. (Наследуется из Publication.) | |
ScriptMergeDynamicSnapshotJob | Generates a Transact-SQL script that can be used to re-create the Snapshot Agent job that generates a Subscriber's partitioned data snapshot for publications with a parameterized row filter. | |
ScriptMergePartition | Generates a Transact-SQL script that can be used to re-create a Subscriber partition for publications with a parameterized row filter. | |
ScriptPublicationActivation | Generates a Transact-SQL script that, when run, sets the status of a merge publication to active. | |
StartSnapshotGenerationAgentJob | Starts the job that generates the initial snapshot for the publication. (Наследуется из Publication.) | |
StopSnapshotGenerationAgentJob | Attempts to stop a running Snapshot Agent job. (Наследуется из Publication.) | |
ToString | (Наследуется из Object.) | |
ValidatePublication | Marks all subscriptions for validation during the next synchronization. | |
ValidateSubscription | Marks the specified subscription for validation during the next synchronization. |
В начало
Свойства
Имя | Описание | |
---|---|---|
AltSnapshotFolder | Gets or sets the alternate snapshot file location for a publication. (Наследуется из Publication.) | |
Attributes | Gets or sets the publication attributes. (Наследуется из Publication.) | |
AutomaticReinitializationPolicy | Gets or sets whether changes at the Publisher are uploaded to the Publisher when a subscription is reinitialized because of a change in the publication. | |
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Наследуется из ReplicationObject.) | |
CompatibilityLevel | Gets or sets the earliest version of Microsoft SQL Server that can subscribe to the merge publication. (Перезаписывает Publication. . :: . .CompatibilityLevel.) | |
ConflictRetention | Gets or sets the number of days that conflict data rows are retained in conflict tables. (Наследуется из Publication.) | |
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (Наследуется из ReplicationObject.) | |
CreateSnapshotAgentByDefault | Gets or sets if the Snapshot Agent job is added automatically when the publication is created. (Наследуется из Publication.) | |
DatabaseName | Gets or sets the name of the publication database. (Наследуется из Publication.) | |
Description | Gets or sets a textual description of the publication. (Наследуется из Publication.) | |
FtpAddress | Gets or sets the address of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. (Наследуется из Publication.) | |
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. (Наследуется из Publication.) | |
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. (Наследуется из Publication.) | |
FtpPort | Gets or sets the port of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. (Наследуется из Publication.) | |
FtpSubdirectory | Gets or sets the subdirectory on the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP. (Наследуется из Publication.) | |
HasSubscription | Gets whether the publication has one or more subscriptions. (Наследуется из Publication.) | |
IsExistingObject | Gets whether the object exists on the server or not. (Наследуется из ReplicationObject.) | |
MaxConcurrentDynamicSnapshots | Gets or sets the maximum number of concurrent Snapshot Agent sessions supported when generating data snapshots when the publication has a parameterized row filter. | |
MaxConcurrentMerge | Gets or sets the maximum number of Merge Agents that can synchronize with the publication concurrently. | |
MergeArticles | Gets the existing articles in the merge publication. | |
MergeSubscriptions | Gets the subscriptions that belong to a merge publication. | |
Name | Gets or sets the name of the publication. (Наследуется из Publication.) | |
PartitionGroupsOption | Gets or sets whether precomputed partitions should be used to optimize the synchronization process. | |
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. (Наследуется из Publication.) | |
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. (Наследуется из Publication.) | |
Priority | Инфраструктура. | |
PubId | Gets the value that uniquely identifies the publication. (Наследуется из Publication.) | |
ReplicateDdl | Gets or sets the data definition language (DDL) replication options that determine if DDL changes are replicated. (Наследуется из Publication.) | |
RetentionPeriod | Gets or sets the amount of time before a subscription expires when the subscription is not synchronized with the publication. (Наследуется из Publication.) | |
RetentionPeriodUnit | Gets or sets the unit in which the RetentionPeriodUnit property is expressed. | |
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. (Наследуется из Publication.) | |
SnapshotAgentExists | Gets if the SQL Server Agent job exists to generate the initial snapshot for this publication. (Наследуется из Publication.) | |
SnapshotAvailable | Gets or sets whether the snapshot files for this publication have been generated and are available to initialize Subscribers. | |
SnapshotGenerationAgentProcessSecurity | Gets an object that sets the Windows account under which the Snapshot Agent job runs. (Наследуется из Publication.) | |
SnapshotGenerationAgentPublisherSecurity | Gets the security context used by the Snapshot Agent to connect to the Publisher. (Наследуется из Publication.) | |
SnapshotJobId | Gets the Snapshot Agent job ID for the current publication. (Наследуется из Publication.) | |
SnapshotMethod | Gets or sets the data file format of the initial snapshot. (Наследуется из Publication.) | |
SnapshotSchedule | Gets an object that sets the schedule for the Snapshot Agent for the current publication. (Наследуется из Publication.) | |
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (Наследуется из ReplicationObject.) | |
Status | Gets or sets the status of the publication. (Наследуется из Publication.) | |
Type | Gets or sets the type of publication. (Наследуется из Publication.) | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (Наследуется из ReplicationObject.) | |
UsesHostName | Gets whether the merge publication has a parameterized row filter that uses the HOST_NAME function to evaluate the partition. | |
ValidateSubscriberInfo | Gets or sets the functions that are used to define a Subscriber partition of the published data when parameterized row filters are used. | |
WebSynchronizationUrl | Gets or sets the URL used with Web synchronization. |
В начало