Table 10-1 lists the Replication Server commands used to work with 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 defintion command. For example, it:
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:
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:
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”. |
Also, see Table 9-1 and Table 11-3.
