Change Data Capture (CDC)
Closed this issue · 0 comments
phongnguyend commented
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