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.

Replication Server stores information about table schema in a table replication definition.

When a replication definition is altered, Replication Server may create a new replication definition version. Replication Server processes old data rows that are already in the replication system using the old replication definition version, while processing new data rows entering the Replication Server system using the new replication definition version.

For databases that do not support rs_send_repserver_cmd, verify that the data row using the old replication definition is no longer in the database log before you issue the alter replication definition request at the primary Replication Server.

Related tasks
Using the Replication Definition Change Request Process