A publication is a collection of one or more articles from one database. The grouping of multiple articles into a publication makes it easier to specify a logically related set of database data and objects that are replicated as a unit.
A publication is a collection of one or more articles from one database. The grouping of multiple articles into a publication makes it easier to specify a logically related set of database data and objects that are replicated as a unit.
Base Class | Microsoft.SQLServer.Replication.Library.GenericPublication |
Abstract | False |
Hosted | True |
Singleton | False |
Extension | False |
Accessibility | Public |
ElementId | efbf7ebb-c349-3dbe-9c0f-ef63a90b689f |
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.GenericPublication: | |||||||||
string | Publication Name | Instance name: [SubscriptionName] | true | 256 | 0 | False | |||
string | Publication Database | Database | false | 256 | 0 | False | |||
string | Publication Description | Description | false | 256 | 0 | False | |||
string | Publication Type | Type | false | 256 | 0 | False | |||
bool | Subscription Expiration | If “retention” is zero - false | false | 256 | 0 | ||||
string | Expiration Interval | “retention” field, hours for usual, days for merge | false | 256 | 0 | False | |||
string | Snapshot Format | “synchronization method”: 0 – native, 1 - character | false | 256 | 0 | False | |||
string | Location of Snapshot Files | “alt_snapshot_folder” for alternative location “snapshot_in_defaultfolder” for “use default folder” Sp_help_distributor.”directory” for default folder. |
false | 260 | 0 | False |
<ClassType ID="Microsoft.SQLServer.2008.Replication.Publication" Base="MSRL!Microsoft.SQLServer.Replication.Library.GenericPublication" Accessibility="Public" Abstract="false" Hosted="true" Singleton="false"/>