When a source is replicating to multiple targets, it may be desired to have different Capture parameter settings for various targets in question. For example, it may be desired to enable DDL replication for one target whereas for others we may not want to replicate DDL. This solution delves on the feasibility of this.
General information.
Shareplex does not allow setting of Capture parameters target wise. In a replication involving one source and multiple targets, the Capture parameter setting will apply to all targets in question. This does not apply to Export parameters which can be set differently for various targets. But for Capture this restriction exists. The only way this can be achieved is to set different Shareplex instances with varying Capture parameter settings on source server to cater to various targets, and consequently set up target Shareplex instances on different ports so that they are different entities. But this will require more resources, monitoring, etc.
