Change data capture

The change data capture (CDC) feature in SQL Server is a valuable way to ingest data from a source, transform it, and then publish it to new tables or a secondary database. This feature is now available in SQL Server 2019 for Linux.  

As the code base is the same in SQL Server for Linux as it is for Windows, the same process is required to enable the feature:

EXEC sys.sp_cdc_enable_db

This will create the system objects, the CDC user, metadata, and the CDC schema as part of the procedure to set up CDC.

The same templates available from SQL Server Management Studio (SSMS) in the Template Explorer will work for CDC in Linux and can speed up the process of implementing a CDC solution.