Table-valued functions are provided to allow systematic access to the change data by consumers.Ī good example of a data consumer that this technology targets is an extraction, transformation, and loading (ETL) application. Column information and the metadata that is required to apply the changes to a target environment is captured for the modified rows and stored in change tables that mirror the column structure of the tracked source tables. This makes the details of the changes available in an easily consumed relational format. OverviewĬhange data capture (CDC) uses the SQL Server agent to record insert, update, and delete activity that applies to a table. Change data capture is generally available in Azure SQL Database, SQL Server, and Azure SQL Managed Instance. In this article, learn about change data capture (CDC), which records activity on a database when tables and rows have been modified.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |