You can use set replication to control replication of DML and/or DDL commands and procedures for an isql session.
Execute set replication at the Adaptive Server that manages the active database. The syntax is:
set replication [on | force_ddl | default | off]
The default setting is “on.” Default behavior depends on whether or not the database has been marked for replication with sp_reptostandby. Table 3-3 describes the default behavior of set replication.
If the database has been marked for replication with sp_reptostandby |
If the database has not been marked for replication with sp_reptostandby |
|---|---|
Replication Server copies DML and supported DDL commands to the standby database for all user tables. |
Replication Server copies DML commands to standby and replicate databases for tables marked with sp_setreptable. |
Some examples of set replication follow. See Chapter 5, “Adaptive Server Commands and System Procedures” in the Replication Server Reference Manual for more information about set replication command.
