Replication Server article column property sheets contain all the standard article column tabs, along with the RepServer Options tab.
The RepServer Options tab contains the following properties:
Property |
Description |
---|---|
Column replication type |
Specifies an event for the replication of an article column. You can choose from one of the following values:
Scripting name: ColumnReplication |
Primary key |
Specifies whether the column is a primary key column. Scripting name: IsPrimary |
Mandatory |
Specifies whether the column is mandatory in the replicated table. Scripting name: IsMandatory |
Searchable |
Specifies whether the article column is searchable. Scripting name: Searchable |
Data type |
Specifies the datatype of a column after a column-level datatype translation, but before any class-level translation and presentation to the replicated database. Scripting name: PublishedDataType |
Identity (v15.1 and higher) |
Specifies an article column computed from a table column when the source column attribute is specified. Only numerical typed column such as integer, numeric, or smallint can have this property. Scripting name: Identity |
References (v15.5 and higher) |
Specifies a referential constraint (include foreign key and check constraints) to another table. During the bulk applying time, HVAR replication will load inserts (or deletes) to the referenced tables before (or after) the replication definition table. Scripting name: References |