Altering a function replication definition

  1. Quiesce the replication system using the Sybase Central Replication Manager plug-in or the procedure described in the Replication Server Troubleshooting Guide.

    Quiesce first the primary updates and ensure that all primary updates have been processed by the replication system. If you are unable to do that, then the old updates in the primary log will not have values for new parameters, and the replication system will use nulls. Take this into account when altering function strings in step 4.

  2. Alter the stored procedure at the primary and the replicate sites.

  3. Alter the function replication definition. Wait for the modified function replication definition to arrive at the replicate sites.

  4. Alter any function strings pertaining to the function replication definition, if necessary. Wait for the modified function strings to arrive at the replicate sites.

  5. Modify subscriptions on the function replication definition at replicate sites, if necessary. To modify a subscription, drop and re-create it using drop subscription and create subscription (with no materialization option).

    Altering a request or applied replication definition does not affect current subscriptions. If new parameters are added to the function replication definition, they are replicated with any new updates for all existing subscriptions.

  6. Resume updates to the data at the primary database.