Replication Server Replication Definition and Article Properties

Replication Server replication definition and article property sheets contain all the standard article tabs, along with the RepServer Options tab, the details of which are listed below.

Property

Description

Enable replication

Enables replication for a table.

Primary table name

Specifies the name of the table in the primary database to be replicated.

Scripting name: PrimaryTableName

Replication definition name

Specifies the name of the replication definition.

Scripting name: ReplicationDefinitionName

Multiple owner

Specifies the mode of the table to replicate, so that both the table name and the owner name are considered for replication.

Scripting name: MultipleOwner

Column replication type

Specifies the type of the column replication: "all columns", "minimal columns".

Scripting name: ColumnReplication

Standby type

Specifies the type of standby: "all", "replication definition".

Scripting name: StandBy

Dynamic SQL

(Replication Server 15.1 and higher) Specifies the mode (on, off, default) of the connection so that the replication definition allows the execution of dynamic SQL statements. Additional configuration parameters linked to dynamic SQL are only available when the mode is set to "on".

Scripting name: DynamicSQL


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com