MergeSynchronizationAgent Properties

 

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

NameDescription
System_CAPS_pubpropertyAlternateSynchronizationPartnerCollection

Gets the alternate synchronization partners for a subscription.

System_CAPS_pubpropertyAltSnapshotFolder

Gets or sets the alternate snapshot folder for the subscription.

System_CAPS_pubpropertyComErrorCollection

Gets a collection of errors generated by the replication agent.

System_CAPS_pubpropertyDistributor

Gets or sets the name of the instance of Microsoft SQL Server that is acting as the Distributor for the subscription.

System_CAPS_pubpropertyDistributorAddress

Gets or sets the network address that is used to connect to the Distributor when the DistributorNetwork property is specified.

System_CAPS_pubpropertyDistributorEncryptedPassword

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the distributor encrypted password.

System_CAPS_pubpropertyDistributorLogin

Gets or sets the login name that is used when connecting to the Distributor using SQL Server Authentication.

System_CAPS_pubpropertyDistributorNetwork

Gets or sets the client Net-Library that is used when connecting to the Distributor.

System_CAPS_pubpropertyDistributorPassword

Sets the password that is used when connecting to the Distributor using SQL Server Authentication.

System_CAPS_pubpropertyDistributorSecurityMode

Gets or sets the security mode used when connecting to the Distributor.

System_CAPS_pubpropertyDownloadGenerationsPerBatch

Gets or sets the number of generations to be processed in a single batch while downloading changes from the Publisher to the Subscriber. A generation is defined as a logical group of changes per article.

System_CAPS_pubpropertyDynamicSnapshotLocation

Gets or sets the location of the partitioned snapshot for this Subscriber.

System_CAPS_pubpropertyExchangeType

Gets or sets how data is exchanged during synchronization.

System_CAPS_pubpropertyFileTransferType

Gets or sets how the initial snapshot files are transferred to the Subscriber.

System_CAPS_pubpropertyHostName

Gets or sets the value used by the Merge Agent when it evaluates a parameterized filter that uses the HOST_NAME function.

System_CAPS_pubpropertyInputMessageFile

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the input message file.

System_CAPS_pubpropertyInternetLogin

Gets or sets the login name that is used with Web synchronization when connecting to the Publisher by using Internet authentication.

System_CAPS_pubpropertyInternetPassword

Sets the password for the InternetLogin property that is used with Web synchronization when connecting to the Publisher by using Internet authentication.

System_CAPS_pubpropertyInternetProxyLogin

Gets or sets the login name that is used with Web synchronization when connecting to the Web server by using an Internet proxy server.

System_CAPS_pubpropertyInternetProxyPassword

Sets the password for the login that is used with Web synchronization when connecting to the Web server by using an Internet proxy server.

System_CAPS_pubpropertyInternetProxyServer

Gets or sets the name of the Internet proxy server that is used with Web synchronization when connecting to the Web server.

System_CAPS_pubpropertyInternetSecurityMode

Gets or sets the HTTP authentication method that is used when connecting to the Web server during Web synchronization.

System_CAPS_pubpropertyInternetTimeout

Gets or sets the HTTP time-out when connecting to the Web server.

System_CAPS_pubpropertyInternetUrl

Gets or sets the URL of the Web service that is configured for Web synchronization.

System_CAPS_pubpropertyLastUpdatedTime

Gets the timestamp of the last time that replication agent synchronized the subscription.

System_CAPS_pubpropertyLoginTimeout

Gets or sets the maximum number of seconds to wait for connections to be established.

System_CAPS_pubpropertyMetadataRetentionCleanup

Get or sets whether to clean up metadata.

System_CAPS_pubpropertyOutput

Gets or sets the agent output file.

System_CAPS_pubpropertyOutputMessageFile

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the input message file.

System_CAPS_pubpropertyOutputVerboseLevel

Gets or sets the level of detail of information that is written to the agent output file.

System_CAPS_pubpropertyProfileName

Gets or sets the name of the profile that is used by the agent.

System_CAPS_pubpropertyPublication

Gets or sets the name of the publication.

System_CAPS_pubpropertyPublisher

Gets or sets the name of the instance of Microsoft SQL Server that is the Publisher for the subscription.

System_CAPS_pubpropertyPublisherAddress

Gets or sets the network address that is used to connect to the Publisher when the PublisherNetwork property is specified.

System_CAPS_pubpropertyPublisherChanges

Gets the total number of Publisher changes that were applied at the Subscriber during the last synchronization.

System_CAPS_pubpropertyPublisherConflicts

Gets the total number of conflicts that occurred at the Publisher during the last synchronization.

System_CAPS_pubpropertyPublisherDatabase

Gets or sets the name of the publication database.

System_CAPS_pubpropertyPublisherEncryptedPassword

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the publisher encrypted password.

System_CAPS_pubpropertyPublisherFailoverPartner

Gets or sets the failover partner instance of SQL Server that is participating in a database mirroring session with the publication database.

System_CAPS_pubpropertyPublisherLogin

Gets or sets the login name that is used when connecting to the Publisher by using SQL Server Authentication.

System_CAPS_pubpropertyPublisherNetwork

Gets or sets the client Net-Library that is used when connecting to the Publisher.

System_CAPS_pubpropertyPublisherPassword

Sets the password that is used when connecting to the Publisher by using SQL Server Authentication.

System_CAPS_pubpropertyPublisherSecurityMode

Gets or sets the security mode that is used when connecting to the Publisher.

System_CAPS_pubpropertyQueryTimeout

Gets or sets the number of seconds that are allowed for internal queries to finish.

System_CAPS_pubpropertySecureDistributorEncryptedPassword

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the secure distributor encrypted password.

System_CAPS_pubpropertySecurePublisherEncryptedPassword

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the secure publisher encrypted password.

System_CAPS_pubpropertySecureSubscriberEncryptedPassword

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the secure subscriber encrypted password.

System_CAPS_pubpropertySubscriber

Gets or sets the name of the instance of Microsoft SQL Server that is the Subscriber.

System_CAPS_pubpropertySubscriberChanges

Gets the total number of Subscriber changes that were applied at the Publisher during the last synchronization.

System_CAPS_pubpropertySubscriberConflicts

Gets the total number of conflicts that occurred at the Publisher during the last synchronization.

System_CAPS_pubpropertySubscriberDatabase

Gets or sets the name of the subscription database.

System_CAPS_pubpropertySubscriberDatabasePath

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the subscriber database path.

System_CAPS_pubpropertySubscriberDataSourceType

Gets or sets the type of data source that is used as the Subscriber.

System_CAPS_pubpropertySubscriberEncryptedPassword

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the subscriber encrypted password.

System_CAPS_pubpropertySubscriberLogin

Gets or sets the login name used that is when connecting to the Subscriber by using SQL Server Authentication.

System_CAPS_pubpropertySubscriberPassword

Sets the password that is used when connecting to the Subscriber by using SQL Server Authentication.

System_CAPS_pubpropertySubscriberSecurityMode

Gets or sets the security mode used when connecting to the Subscriber.

System_CAPS_pubpropertySubscriptionType

Gets or sets whether the subscription is a push or pull subscription.

System_CAPS_pubpropertySyncToAlternate

Gets or sets whether the synchronization is to an alternate synchronization partner.

System_CAPS_pubpropertyUploadGenerationsPerBatch

Gets or sets the number of generations to be processed in a single batch while uploading changes from the Subscriber to the Publisher. A generation is defined as a logical group of changes per article.

System_CAPS_pubpropertyUseInteractiveResolver

Gets or sets whether the interactive resolver is used during reconciliation.

System_CAPS_pubpropertyUseWebSynchronization

Gets or sets whether Web synchronization is used.

System_CAPS_pubpropertyValidate

Gets or sets whether data validation is performed on the Subscriber data at the end of the synchronization.

System_CAPS_pubpropertyWorkingDirectory

Gets or sets the working directory from which snapshot files are accessed when FTP is used.

Return to top
Show: