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 all user tables by executing sp_reptostandby with the use_index option:
sp_reptostandby dbname, [[, 'L1' | 'ALL'][, use_index]]
where dbname is the name of the active database. With the use_index option, the database is marked to use indexes on text, unitext, image, or rawobject columns, and internal indexes are created on those tables not explicitly marked for replication.
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'
