Use sp_reptostandby to copy DML and supported DDL commands for all user tables to the standby database.
To enable replication of DML and DDL commands, execute sp_reptostandby in the Adaptive Server that manages the active database:
sp_reptostandby dbname, [[, 'L1' | 'ALL' | 'NONE' ] [, use_index]]
where dbname is the name of the active database and the keywords L1, all, and none set the level of replication support.
L1 represents the level of replication supported by Adaptive Server version 12.5.
Use the all keyword to make sure that schema replication support is always at the highest level available. For example, to set the schema replication support level to that of the latest Adaptive Server version, log in to Adaptive Server and execute this command at the isql prompt:
sp_reptostandby dbname, 'all'
Then, if the database is upgraded to a later Adaptive Server version with a higher level of replication support, all new features of that version are enabled automatically.
If a DDL command or system procedure contains password information, the password information is sent through the replication environment using the cipher text password value stored in the source Adaptive Server system tables.
See Replication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_reptostandby.