I am currently investigating whether to use the SQL Server feature Change Data Capture (CDC) for a data framework I am developing.
During my research I found much on how to use CDC, but not as much about when to use: In what kind of scenarios is CDC useful? (Point-in-time restoration of entries/audit/viewing change history) Where are its weaknesses compared to manual history tracking (e.g. trigger-based)?
So I came to dba in the hopes of finding an answer. Before I asked the question myself, I searched the existing questions and found this:
The question asks if CDC is useful in the given scenario. I would expect the answers to give an overview of when CDC is useful and when rather not to use it.
However, the question got closed for being too localized ("unlikely to help any future visitors") which is not true, because it likely would have helped me.
Is there any chance to reopen this question, maybe if we rephrased it to be a little bit more general? (What are valid usage scenarios/advantages of CDC?)
Should I rather open a new question? Or is the information I seek for not within the scope of this site?