Default behavior for create index/drop index for replicated tables in 7.5 (4269382)

In earlier versions before 7.5, create index/drop index are not being replicated with default setting of SP_OCT_REPLICATE_ALL_DDL=0 and SP_OCT_REPLICATE_DDL=3.

However in 7.5, create index/drop index will be replicated for tables in replication even if the config file is created without using wildcard.

there is a new parameter called SP_OCT_AUTOADD_ENABLE which defaults to 1 and with SP_OCT_REPLICATE_ALL_DDL=0, create index/drop index will be replicated for tables in replication

If you don't want to replicate 'create index/drop index' for tables in replication and you are not using wildcard in config file, then you need to set SP_OCT_AUTOADD_ENABLE=0 on source server

sp_ctrl> stop capture

sp_ctrl> set param SP_OCT_AUTOADD_ENABLE 0

sp_ctrl> start capture

This maybe useful for peer to peer replication if you are currently not replicating ddls.

If you are not replicating create/drop index for replicated tables, then you need to stop post on target and manually create/drop the index on target.