DDL replication is only available for Oracle.
For database definition language (DDL) to be replicated, the pdb_setrepddl command must be set to enable. If pdb_setrepddl is set to enable, all DDL in your primary database is replicated.
To replicate DDL, Replication Server must have a database-level replication
definition with replicate DDL set in the definition.
See the Replication Server Reference Manual for
details on creating a database-level replication definition.
To enable replication for DDL in the primary database
Log in to the Replication Agent administration port.
Use the pdb_setrepddl command without an argument to determine if replication is already enabled for DDL in the primary database:
pdb_setrepddl
If the pdb_setrepddl command returns information that replication is enabled, you need not continue this procedure.
If the pdb_setrepddl command returns information that replication is not enabled for DDL, continue this procedure to enable replication for DDL.
Use the pdb_setrepddl command to enable replication for DDL:
pdb_setrepddl enable
After replication is enabled for the DDL, you can begin replicating your primary database.
See the Sybase Replication Agent Primary Database Guide for enabling DDL replication details specific to your primary database.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
