Modify Replication Definitions

Learn how to view, alter, and drop replication definitions and learn how Replication Server supports table changes.

See Replication Server Administration Guide Volume 2 > Manage Warm Standby Applications > Use Replication Definitions and Subscriptions > Create Replication Definitions for Warm Standby Databases > alter table Support for Warm Standby for alter table changes that affect warm standby tables with no subscriptions.

• Maintain Table Schema
  To coordinate primary schema or store procedure changes with the corresponding replication definition changes, use the rs_send_repserver_cmd stored procedure to execute replication definition requests at the primary database, while you are changing the primary schema or stored procedure.
• View Replication Definitions and Replication Definition Versions
  Use the rs_helprep and rs_helpreptable stored procedures to display information about existing replication definitions, and the rs_helprepversion stored procedure to display information on replication definition versions.
• Alter Replication Definitions
  You may need to alter a replication definition after a column has been added to a primary table or if a destination database requires a column that was not specified in the original replication definition.
• Drop Replication Definitions
  Learn how to drop replication definitions.