Disabling replication for stored procedures  Enabling replication for DDL

Chapter 3: Administering Sybase Replication Agent

Enabling and disabling replication for DDL

NoteDDL replication is available only for Oracle. See the Replication Agent Primary Database Guide for more information on the DDL commands that that are not replicated.

If you need to temporarily suspend replication of DDL, you can use the pdb_setrepddl command to disable replication of DDL. When you are ready to resume replication of DDL, you can use the pdb_setrepddl command to enable replication.

When you set the value of pdb_setrepddl to enable, all DDL in your primary database is replicated.

NoteTo 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.





Copyright © 2005. Sybase Inc. All rights reserved. Enabling replication for DDL

View this book as PDF