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. Scripting name: EnableReplicate |
|
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 |
Threshold (v15.2 and higher) |
Specifies the minimum number of rows that a replicated SQL statement must impact before SQL statement replication is activated. Scripting name: RepDefThreshold |
|
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:
Scripting name: ReplicateSQLDML |
|
Request alter from primary database (v15.5 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 |