Single MS Sql Server CDC source - to multiple SQL Server targets

[RonFusionHSLLC]

Is it possible to use a single source MS Sql Server MSCDC in several tasks and use different targets without conflicts.

[Dineshan]

Hello @RonFusionHSLLC,

If the source is not going to change then you should consider using LogStream. This way you can have one parent task and multiple child tasks with different targets. Link to user guide below.

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Log%20Stream%20Staging/int...

Thank you,

Dinesh

[RonFusionHSLLC · Accepted solution]

If I don't mind the extra overhead, can it be done without logstream?   This is a temp situation so would like to take the path of least resistance

[Dineshan]

Hello @RonFusionHSLLC,

Yes, it would still work fine.

Thank you,

Dinesh

[RonFusionHSLLC]

Perfect...thanks