Commands for Managing Table Replication Definitions

Replication Server provides commands and stored procedures to manage table replication definitions.

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.

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

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.

rs_send_repserver_cmd

Executes replication definition change requests directly at the primary database.

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.

admin verify_repserver_cmd

Verifies that Replication Server can successfully execute a replication definition change request.

Related concepts
Create Replication Definitions
Alter Replication Definitions
Drop Replication Definitions
Execute Replication Definition Changes Directly at the Primary Database
Verify Replication Definition RCL Commands
Related tasks
Using the Replication Definition Change Request Process