DDL Replication

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

NoteNo translation or adjustment of DDL commands is provided by Replication Agent. DDL commands should therefore only be replicated to other Microsoft SQL Server databases.

Replication of DDL commands is enabled or disabled in Replication Agent using the pdb_setrepddl command. See the Replication Agent Reference Manual for details on 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.