search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.24k stars 21.41k forks source link

Azure Hyperscale Database does not support Change data capture #53976

Closed srini1978 closed 4 years ago

srini1978 commented 4 years ago

28079 issue states that Azure hyperscale database supports Change data capture. But it looks like it is not supported.

It is listed in the below table

https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/sql-database/sql-database-features.md#sql-features

FYI @Mike-Ubezzi-MSFT

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

SamaraSoucy-MSFT commented 4 years ago

Thanks for the feedback! I have assigned the issue to the doc author to update appropriately.

Mike-Ubezzi-MSFT commented 4 years ago

@srini1978 The Change Data Capture is supported by SQL Server and Azure SQL Database Managed Instance. It is not supported by Azure SQL Database single instance, elastic pool, or Hyperscale instances. Change Tracking is a lightweight solution (as compared to Change Data Capture) that is supported by Azure SQL Database single instance which also includes elastic pools and Hyperscale. Change Data Capture will let you know how many times a row has changed. Change Tracking will let you know that a row has changed. Very similar but SQL Server and Azure SQL Database Managed Instance have the transactional logs to support the Change Data Capture functionality. I apologize for any confusion I may have caused but I think there are multiple points being discussed in the comment from the previous issue.

Mike-Ubezzi-MSFT commented 4 years ago

@srini1978 We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.