In this article Im going to configure change data capture. Im going to create a new database and a table for this purpose. Configuring CDC is very simple its just a two step process as below
-
Enable CDC for the database
-
Enable CDC for the required tables