To set up a table for replication, mark it as replicated in Adaptive Server and define a replication definition for it in Replication Server. The replication definition describes the table and contains information about the columns to be replicated.
If you plan to replicate stored procedures, create the stored procedure in both the primary and replicate database.
If you are replicating the procedure from the primary to replicate database, mark the stored procedure for replication in the primary database.
If you are replicating the procedure from the replicate to the primary database, mark the stored procedure for replication in the replicate database.
Create a function replication definition for the stored procedure at the primary Replication Server, even if you are replicating the stored procedure from a replicate database to the primary database.
Refer to Chapter 9, “Managing Replicated Tables” for more information about creating replication definitions. Refer to Chapter 10, “Managing Replicated Functions” for more information about replicated function delivery.
