Microsoft.SQLServer.2016.Replication.SubscriptionMSSQL 2016 Replication: Subscription

Microsoft.SQLServer.2016.Replication.Subscription (ClassType)

SQL Server 2016 Subscription is a request for a copy of a publication to be delivered to a Subscriber.

Knowledge Base article:

Summary

A subscription is a request for a copy of a publication to be delivered to a Subscriber. The subscription defines what publication will be received, where, and when. There are two types of subscriptions: push and pull. For more information about push and pull subscriptions, see Subscribe to Publications.

Element properties:

Base ClassMicrosoft.SQLServer.Replication.Library.GenericSubscription
AbstractFalse
HostedTrue
SingletonFalse
ExtensionFalse
AccessibilityPublic
ElementId0abfc2fb-e8c1-1f2c-c04a-23845fa36fd7

Class Hierarchy:

Class Properties:

Property Name Type Display Name (ENU) Description (ENU) Key Max Length Min Length Case Sensitive Default Value EnumType
System.Entity:
DisplayName  string  Display Name Display name of the object. false 4000  False     
System.ConfigItem:
ObjectStatus  enum  Object Status Object status false 256    System.ConfigItem.ObjectStatusEnum.Active  System.ConfigItem.ObjectStatusEnum 
AssetStatus  enum  Asset Status Asset status false 256      System.ConfigItem.AssetStatusEnum 
Notes  richtext  Notes Notes false 4000       
Microsoft.SQLServer.Replication.Library.GenericSubscription:
SubscriptionName  string  Subscription Name Instance name: [SubscriptionName] true 256  False     
Type  string  Subscription Type false 256  False     
Publisher  string  Publisher The server instance where the publication originates. false 256  False     
Distributor  string  Distributor The Distributor used by the publisher. false 256  False     
PublicationDatabase  string  Publication Database The server instance where the publication originates. false 256  False     
PublicationName  string  Publication Name The publication name. [Just the name without the full pass as in the key property] false 256  False     
ReplicationType  string  Replication Type Type of replication false 256  False     
Subscriber  string  Subscriber The server instance that receives the subscription. false 256  False     
SubscriptionDatabase  string  Subscription Database The database that receives the subscription. false 256  False     
SubscriptionDescription  string  Subscription Description The description of the subscription. false 300  False     
UpdatableSubscription  bool  Updatable Subscription Determines whether Subscriber changes are replicated. false 256       
UseWindowsSynchronizationManager  bool  Use Windows Synchronization Manager Determines whether the subscription can be synchronized using Windows Synchronization Manager. false 256       

Health Model:

Source Code:

<ClassType ID="Microsoft.SQLServer.2016.Replication.Subscription" Base="MSRL!Microsoft.SQLServer.Replication.Library.GenericSubscription" Accessibility="Public" Abstract="false" Hosted="true" Singleton="false"/>