DDL Replication

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

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

Replication of DDL commands is enabled or disabled in Mirror Replication Agent using the pdb_setrepddl command. For details on this command, see the Mirror Replication Agent Reference Manual.

Replication Server uses the ddl_username parameter to execute DDL commands in the standby database as the same user who executed the DDL commands in the primary database.