You can enable replication for tables in the active database in either of two ways:
Use sp_reptostandby to mark the database for replication, enabling replication of data and supported schema changes.
Use sp_setreptable to mark individual tables for replication of data changes.
Refer to “What information is replicated?” for more information about these commands.
Log in to the Adaptive Server as the System Administrator or as the Database Owner, and:
use active_database
Mark database tables for replication, using one of these methods:
Mark all user tables by executing the sp_reptostandby system procedure:
sp_reptostandby dbname, [ 'L1' | 'all' ]
where dbname is the name of the active database, L1 sets the replication level to that of Adaptive Server version 11.5, and all sets the replication level to the current version of Adaptive Server. This method replicates both DML and DDL commands and procedures.
Mark individual user tables by executing the sp_setreptable system procedure for each table that you want to replicate into the standby database:
sp_setreptable table_name, 'true'
where table_name is the name of the table. This method replicates DML commands.
If you are using the replicated functions feature described in Chapter 10, “Managing Replicated Functions,” in the Replication Server Administration Guide Volume 1, execute the following system procedure for every stored procedure whose executions you want to replicate into the standby database:
sp_setrepproc proc_name, 'function'
If you are using replicated stored procedures associated with table replication definitions, as described in Appendix A, “Asynchronous Procedures,” execute the following system procedure for every such stored procedure whose executions you want to replicate into the standby database:
sp_setrepproc proc_name, 'table'
