DDL Commands and Objects Filtered from Replication

These database-scope DDL commands are not replicated.

  • ALTER_APPLICATION_ROLE

  • ALTER_ASSEMBLY

  • ALTER_AUTHORIZATION_DATABASE

  • ALTER_CERTIFICATE

  • CREATE_APPLICATION_ROLE

  • CREATE_ASSEMBLY

  • CREATE_CERTIFICATE

  • CREATE_EVENT_NOTIFICATION

  • DROP_EVENT_NOTIFICATION

These server-scope DDL commands are not replicated:

  • ALTER_AUTHORIZATION_SERVER

  • ALTER_DATABASE

  • ALTER_LOGIN

  • CREATE_DATABASE

  • CREATE_ENDPOINT

  • CREATE_LOGIN

  • DENY_SERVER

  • DROP_DATABASE

  • DROP_ENDPOINT

  • DROP_LOGIN

  • GRANT_SERVER

  • REVOKE_SERVER

Any object owned by users defined in the list of nonreplicated users is not replicated. You can modify this list using the pdb_ownerfilter command. In addition, Sybase has provided a default list of owners whose objects are not replicated. Use the pdb_ownerfilter command to return, add, or remove the list of owners whose objects are not replicated. See the Replication Agent Reference Manual.

Parent topic: DDL Replication