SQL Server 2008 Subscription is a request for a copy of a publication to be delivered to a Subscriber.
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.
Base Class | Microsoft.SQLServer.Replication.Library.GenericSubscription |
Abstract | False |
Hosted | True |
Singleton | False |
Extension | False |
Accessibility | Public |
ElementId | 0ee4a53e-4b6c-b8a3-d30b-5f7c983c60b0 |
Property Name | Type | Display Name (ENU) | Description (ENU) | Key | Max Length | Min Length | Case Sensitive | Default Value | EnumType |
---|---|---|---|---|---|---|---|---|---|
System.Entity: | |||||||||
string | Display Name | Display name of the object. | false | 4000 | 0 | False | |||
System.ConfigItem: | |||||||||
enum | Object Status | Object status | false | 256 | 0 | System.ConfigItem.ObjectStatusEnum.Active | System.ConfigItem.ObjectStatusEnum | ||
enum | Asset Status | Asset status | false | 256 | 0 | System.ConfigItem.AssetStatusEnum | |||
richtext | Notes | Notes | false | 4000 | 0 | ||||
Microsoft.SQLServer.Replication.Library.GenericSubscription: | |||||||||
string | Subscription Name | Instance name: [SubscriptionName] | true | 256 | 0 | False | |||
string | Subscription Type | false | 256 | 0 | False | ||||
string | Publisher | The server instance where the publication originates. | false | 256 | 0 | False | |||
string | Distributor | The Distributor used by the publisher. | false | 256 | 0 | False | |||
string | Publication Database | The server instance where the publication originates. | false | 256 | 0 | False | |||
string | Publication Name | The publication name. [Just the name without the full pass as in the key property] | false | 256 | 0 | False | |||
string | Replication Type | Type of replication | false | 256 | 0 | False | |||
string | Subscriber | The server instance that receives the subscription. | false | 256 | 0 | False | |||
string | Subscription Database | The database that receives the subscription. | false | 256 | 0 | False | |||
string | Subscription Description | The description of the subscription. | false | 300 | 0 | False | |||
bool | Updatable Subscription | Determines whether Subscriber changes are replicated. | false | 256 | 0 | ||||
bool | Use Windows Synchronization Manager | Determines whether the subscription can be synchronized using Windows Synchronization Manager. | false | 256 | 0 |
<ClassType ID="Microsoft.SQLServer.2008.Replication.Subscription" Base="MSRL!Microsoft.SQLServer.Replication.Library.GenericSubscription" Accessibility="Public" Abstract="false" Hosted="true" Singleton="false"/>