We are excited to announce the public preview of change data capture (CDC) in Azure SQL Databases, a feature that has been requested by multiple customers.
What is change data capture?
Change...
Updated Jun 09, 2021
Version 2.0
Blog Post
Will trace flag 8207 be supported with Azure SQL Database when enabling CDC? /cc MaraSteiu
Enables singleton updates for Transactional Replication and CDC. Updates to subscribers can be replicated as a DELETE and INSERT pair. This might not meet business rules, such as firing an UPDATE trigger. With trace flag 8207, an update to a unique column that affects only one row (a singleton update) is replicated as an UPDATE and not as a DELETE or INSERT pair. If the update affects a column on which a unique constraint exists, or if the update affects multiple rows, the update is still replicated as a DELETE or INSERT pair. For more information, see this https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/302341.
This flag is very useful when using CDC to generate change notification messages to downstream services. I believe it is not currently possible to set global trace flags on Azure SQL Database.