Maintaining table schema

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. 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.For databases that do no 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. See “Using the replication definition request process”.