Replication Server Database Replication Definition Properties

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 (v12.6 and higher)

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 (v12.6 and higher)

Specifies the list of tables to replicate for the database.

Scripting name: ReplicateTable

Replicate function (v12.6 and higher)

Specifies the list of stored procedures to replicate for the database.

Scripting name: ReplicateFunction

Replicate transaction (v12.6 and higher)

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 (v12.6 and higher)

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:
  • 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