Commands for Managing Function Replication Definitions

Learn the commands you can use to work with function replication definitions.

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.

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.

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.

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.

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.

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.

rs_send_repserver_cmd

Executes 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.

Related concepts
Modify or Drop Replicated Functions
Execute Replication Definition Changes Directly at the Primary Database
Verify Replication Definition RCL Commands
Related tasks
Implementing an Applied Function
Implementing a Request Function
Related reference
Commands for Managing Table Replication Definitions
Subscription Commands