Commands for managing function replication definitions

Table 10-1 lists the Replication Server commands used to work with function replication definitions.

Table 10-1: Commands for managing function replication definitions

Command

Task

drop function replication definition

Removes a function replication definition from the replication system. You must drop all subscriptions for a function replication definition before you can drop the replication definition. See “Modifying or dropping replicated functions”.

create applied replication definition

Creates an applied function replication definition that describes the stored procedure and its parameters, for both the primary and replicate databases. It also describes the location of the primary data. The maint_user applies the applied function at the replicate site. See “Implementing an applied function”.

create request replication definition

Creates a request function replication definition that describes the stored procedure and its parameters, for both the primary and replicate databases. It also describes the location of the primary data. The same user running the stored procedure at the primary site applies the request function at the replicate site.

alter applied replication definition

Modifies an applied function replication definition, which is created with create applied function replication definition command. For example, it:

  • Specifies a different name for the primary stored procedure invoked at the source database.

  • Specifies a different name for the stored procedure invoked at the destination database.

  • Adds parameters or searchable parameters.

  • Changes how the replication definition is used in replicating to a standby database.

    See “Modifying or dropping replicated functions”

If parameters are added, the change applies to all applied function replication definition created for this primary function.

alter request replication definition

Modifies a request function replication definition, which is created with create request function replication definition command. For example, it:

  • Specifies a different name for the primary stored procedure invoked at the source database.

  • Specifies a different name for the stored procedure invoked at the destination database.

  • Adds parameters or searchable parameters.

  • Changes how the replication definition is used in replicating to a standby database.

See “Modifying or dropping replicated functions”

If parameters are added, the change applies to all request function replication definitions created for this primary function.

create function replication definition

Creates a function replication definition that describes the stored procedure, and its parameters, for replication. It also describes the location of the primary data. This command is deprecated and is replaced by create applied function replication definition and create request function replication definition commands See “Implementing an applied function” and “Implementing a request function”.

alter function replication definition

Modifies a function replication definition. For example, it:

  • Specifies a different name for the stored procedure invoked at the destination database

  • Adds parameters or searchable parameters

  • Changes how the replication definition is used in replicating to a standby database

This command can only be used to modify the function replication definition created with create function replication definition command. See “Modifying or dropping replicated functions”.

rs_send_repserver_cmd

Executes replication definition change requests directly at the primary database. See “Executing replication definition change requests directly at the primary database”.

admin verify_repserver_cmd

Verifies that Replication Server can successfully execute a replication definition change request. See “Verifying replication definition RCL commands”.

Also, see Table 9-1 and Table 11-3.