Commands for managing table replication definitions

Table 9-1 lists the Replication Server commands for working with table replication definitions.

You can use the rs_send_repserver_cmd stored procedure to execute the create replication definition, alter replication definition, and drop replication definition commands at the primary database. See “Using the replication definition request process”.

Table 9-1: Commands for managing table replication definitions

Command

Task

create replication definition

Creates a replication definition for a primary table, which describes the columns you want to copy, the location of the table, and other information. See “Creating replication definitions”.

alter replication definition

Modifies an existing replication definition in a variety of ways, including:

  • Adding or dropping columns

  • Add or drop primary keys

  • Add or drop searchable columns from the replication definition

  • Specifying different replicate table, table owner, column name, or datatype

  • Changing minimal column replication

  • Add or alter column-level datatype translations

  • Change text, unitext, image, or rawobject column replication status

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

See “Altering replication definitions”.

drop replication definition

Removes a replication definition from the replication system. You must drop all subscriptions for a replication definition before you can drop the replication definition. See “Dropping replication definitions”.

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