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 RepServer Options tab contains the following properties:

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(v15.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

Replicate SQLDML (v15.2 and higher)

[ASE primary databases] Enables SQL statement replication. If this option is enabled, you can select any of the following statement types for replication:
  • Update
  • Delete
  • Insert select
  • Select into

Scripting name: ReplicateSQLDML

Request alter from primary database (v15.2 and higher)

Specifies that the alter repdef command will be requested from the primary database.

Scripting name: AlterFromPDB

With DSI_suspended (v15.2 and higher)

Specifies that the with DSI_suspended option will be generated for the alter statement.

Scripting name: SuspendDSI