DDL Replication

Replication of Data Definition Language (DDL) commands is supported.

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.

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.