DDL Replication

Replication of data definition language (DDL) commands is supported, but only to to Microsoft SQL Server databases.

Replication of DDL commands is enabled or disabled in Replication Agent using the pdb_setrepddl command. Replication Server uses the ddl_username parameter to execute DDL commands in the replicate database as the same user who executed the DDL commands in the primary database.

See Replication Agent Reference Manual > Command Reference > pdb_setrepddl and Replication Agent Reference Manual > Configuration Parameters > ddl_username for details on using pdb_setrepddl and ddl_username.

• DDL parameters
  To replicate DDL in Microsoft SQL Server, in addition to setting the value of pdb_setrepddl to enable, set the Replication Agent ddl_username and ddl_password parameters.
• DDL Commands and Objects Filtered from Replication
  These database-scope DDL commands are not replicated.