Replication Server replication definition property sheets contain all the standard publication tabs, along with the RepServer Options tab.
The RepServer Options tab contains the following properties:
Property |
Description |
---|---|
Replicate DDL |
Specifies whether the Data Definition Language (DDL) should be replicated. Scripting name: ReplicateDDL |
DDL User Name (v15.2 and higher) |
[Oracle or SQL Server primary database] Specifies the DDL user name for the replication agent. Scripting name: DDLUserName |
DDL Password (v15.2 and higher) |
[Oracle or SQL Server primary database] Specifies the DDL password for the replication agent. Scripting name: DDLPassword |
Replicate table |
Specifies the list of tables to replicate for the database. Scripting name: ReplicateTable |
Replicate function |
Specifies the list of stored procedures to replicate for the database. Scripting name: ReplicateFunction |
Replicate transaction |
Specifies the list of transactions to replicate for the database. Scripting name: ReplicateTransaction |
Replicate system procedure |
Specifies the list of stored procedures to replicate for the database. Scripting name: ReplicateSystemProcedure |
Transaction set |
Specifies the list of transactions to replicate for the database. Scripting name: TransactionSet |
Threshold (v15.2 and higher) |
[ASE primary databases] Specifies the minimum number of rows that a replicated SQL statement must impact before SQL statement replication is activated for the database. Scripting name: Threshold |
Replicate SQLDML (v15.2 and higher) |
[ASE primary databases] Enables SQL statement replication. If this option is enables, you can select any of the following statement types for replication:
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 |