Using Sql Server Change Data Capture with a frequently changing schema
- by Pete
We are looking into enabling Sql Server Change Data Capture for a new subsystem we are building.
It's not really because we need it, but we are being pushed for having a complete history traceability, and CDC would nicely solve this requirement with minimum effort on our parts.
We are following an agile development process, which in this case…