Preparing for a planned DDL change

In a best case scenario, a DDL change that will affect replication of tables that are being replicated should be known and planned in advance.

In this case you should ensure that the procedure to resume mirroring is executed during a quiescent maintenance period for both source and target systems where no DML changes occur to the CDC Replication in-scope tables (including tables that will not have DDL changes).

Note: The order of the steps for the procedure is important to the success of the execution.