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
The article states "Customers will be able to use CDC on Azure SQL databases higher than the S3 (Standard 3) tier." This would imply that you must be at S4 or higher to use this feature. When I try to enable CDC on a database at the Basic or S0 pricing tier I get the following message.
Change Data Capture is not supported on Free, Basic or Standard tier Single Database (S0,S1,S2)
This would indicate that it must be S3 or higher.
However, I was doing some testing and was able to enable CDC on a database at the S1 pricing tier, enable CDC on one of the tables, and everything worked. This has naturally led to some confusion in our organization as to just what pricing tier (and associated expenses) we should anticipate if we choose to use this solution.
Can you clarify what pricing tier(s) will and will not support CDC?
Thank you.