Change Data Capture (CDC)

[phongnguyend]

https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server
https://www.sqlshack.com/change-data-capture-for-auditing-sql-server/
https://devblogs.microsoft.com/azure-sql/azure-sql-change-stream-with-debezium/
https://github.com/debezium/debezium-examples/tree/main/tutorial#using-sql-server

select name, is_cdc_enabled from sys.databases

EXEC sys.sp_cdc_enable_db

select name, is_tracked_by_cdc from sys.tables


EXEC sys.sp_cdc_enable_table  
@source_schema = N'dbo',  
@source_name   = N'Products',  
@role_name     = NULL,  
@filegroup_name = NULL,  
@supports_net_changes = 0 
GO

EXEC sys.sp_cdc_disable_table  
@source_schema = N'dbo',  
@source_name   = N'Products',  
@capture_instance = 'dbo_Products'
GO


EXEC sys.sp_cdc_disable_db

Communication between multiple docker-compose projects - Stack Overflow