This article describes how to enable and disable change data capture (CDC) for a database and a table for SQL Server and Azure SQL Managed Instance. For Azure SQL Database, see CDC with Azure SQL Database .

In this article, we’ll show how to enable and use the SQL Server Change Data Capture feature. How to set up SQL Server Change Data Capture? The feature is available only in SQL Server Enterprise and Developer editions, starting with. It can …

Dec 19, 2023 · Learn about change data capture (CDC) in SQL Server and Azure SQL Managed Instance, which records insert, update, and delete activity that applies to a table.

Feb 25, 2025 · In this article, we looked at how to set up SQL Server change data capture. We also discussed how to set up Microsoft SQL Server CDC for use with Estuary Flow , the perfect option for setting real-time change data capture pipelines.

Dec 19, 2023 · To change the configuration of a job, use the sys.sp_cdc_change_job stored procedure. For information about database mirroring, see Database Mirroring (SQL Server). Change data capture and transactional replication can coexist in the same database, but population of the change tables is handled differently when both features are enabled.

Feb 26, 2024 · SQL Server 2022 update improves change tracking with Change Data Capture (CDC) and Temporal Tables, offering powerful data management options.

Aug 29, 2022 · This is a post on how to enable Change Data Capture (CDC) in SQL Server. Enabling this on a database and table will allow the recording of activity when tables and rows have been modified. This is a feature available for us to configure within SQL Server and Azure SQL out of the box.

Feb 3, 2025 · Change Data Capture (CDC) is a feature for databases to tracks changes (insert, update, and delete operations) on tables. Each database provider (SQL Server, Oracle, PostreSQL, MySQL) have different approaches to how they achieve this. This article is going to focus on Microsoft SQL Server specifically.

In this post, we will go step by step into several aspects of Change Data Capture, a feature that is available on the Azure SQL Managed Instance and Microsoft SQL Server. The focus will be on the highly optimized SQL Server Change Data Capture feature, its evolution, functions, and types.

Apr 11, 2023 · Change Data Capture (CDC) is a feature in SQL Server that allows you to capture insert, update, and delete operations performed on a SQL Server table and write them to a separate table. This can be useful for a variety of purposes, including auditing, replication, and data warehousing.