Will disabling of DDL replication interfere with SP_OCT_AUTOADD_ENABLE and wildcards (4302256)

For customers that do not replicate any form of DDL, a very valid question arises as to whether SharePlex will still create the tables on target that conform to wildcards in an auto add environment.

The auto add environment refers to a configuration where wildcard notations are used for some or all tables in a config file and the parameter SP_OCT_AUTOADD_ENABLE is set to 1.

When you disable DDL replication by setting one or both of the following:

1. SP_OCT_REPILCATE_DDL to 0 or 2 to disable ALTER TABLE DDL replication and/or TRUNCATE for tables in replication

2. SP_OCT_REPILCATE__ALL DDL to 0 to disable extended DDL replication for tables not in replication

It will not have any bearing on the functioning of auto add feature of SharePlex. The parameter SP_OCT_AUTOADDDD_ENABLE if set to 1 will ensure that all tables that are created on source which conform to the wildcard specifications of the currently active config file will also get created on target and also replicated. This will be irrespective of the DDL settings, whether off or on.  Even though Shareplex will be creating tables on the target as a part of auto add replication, such table creation is outside of the purview of the  exclusion of DDL replication.