How can we improve Azure SQL Database?

Change Data Capture

Allow Change Data Capture in SQL Azure

It has been available in SQL server since 2008, the jump to SQL Azure seems logical.

384 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Daniel Dodds-Wade shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    26 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Phillip Cox commented  ·   ·  Flag as inappropriate

        Totally agree, this feature should be standard for Azure SQL Database, as customers shouldn't have to be limited to something already successfully used on-premises. This type of strategy defeats purpose and any value of moving an organizations on-premises SQL Server instances into cloud. In an ideal world, SQL Server on-premise feature set should be mirrored in the Azure SQL Database offering.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We echo the same sentiments of many of the other comments - need it in standard Azure SQL Databases, not managed

      • Steven Hand commented  ·   ·  Flag as inappropriate

        Thanks for the reply.

        It's imperative you understand that this is NOT a solution. Azure Managed SQL is not Azure SQL.

        It's unreasonable to expect people to migrate from Azure SQL to Azure Managed SQL just to get change data capture, separate from the fact that migrating from Azure SQL to Azure Managed SQL is a backwards migration path.

      • Ray commented  ·   ·  Flag as inappropriate

        We are building an enterprise application in Azure and CDC is an essential part of our solution. Must we really build out own solution when you have the capabilities built in to SQL Server already. I've used CDC and it is great but it does no good to our organization if it is not implemented into Azure soon. What is the ETA on this feature?

      • Anonymous commented  ·   ·  Flag as inappropriate

        We also need this! Is there any plan to release CDC (not change tracking) in Azure soon?

      • Rob commented  ·   ·  Flag as inappropriate

        It's been 2 years since this question was asked. Can we please get an update or roadmap for Change Data Capture in Azure SQL (NOT Change Tracking now, we're asking about CDC here)..

      • Graeme Miller commented  ·   ·  Flag as inappropriate

        This would be a great feature to allow for improved Kafka integration with Azure SQL. Change Tracking isn't sufficient for many scenarios

      • Keith Hays commented  ·   ·  Flag as inappropriate

        I don't understand why the Principal Product Planner would be confused about the difference between Change Tracking and Change Data Capture. We need the functionality of CDC. Change Tracking is not CDC.

      • Matti commented  ·   ·  Flag as inappropriate

        Do you consider MS SSIS to be CDC? It is available. However, we are just implementing IBM IIDR and it is my understanding that SSIS is not great. MS is building up Azure at a tremendous rate so wouldn't be surprised to see it up and running. Maybe the Azure team can provide roadmap for CDC Azure?

      • Steve Kuo commented  ·   ·  Flag as inappropriate

        Change Tracking (CT) is inadequate for our needs. We need Change Data Capture (CDC), for reasons outlined in other posts.

      ← Previous 1

      Feedback and Knowledge Base