Issue with incremental | append sync between MSSQL sources

[slack-user-airbyte]

Summary

When using incremental | append sync with MSSQL source and destination, updates are not reflected, only inserts. Is CDC option required?

Question

hi guys,

do you know if using incremental | append with source mssql and destination mssql, when using query update the data is not updated? only insert that change the data in destination.

is that because I’m not using cdc option?

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

_{["incremental-append", "mssql-source", "mssql-destination", "update", "insert", "cdc"]}