SQL Server

SQL Server Limitations

SQL Server CDC cannot track changes of columns of the ntext, text, and image type when:
- there is no identity set in SQL Server
- the tracking identity set in Changebase includes columns of tye type ntext, text or image.

❗️
Note, that SQL Server has deprecated the ntext, text and image data types.

Configuration

USE $DATABASE_NAME

EXEC sys.sp_cdc_enable_db
GO

EXEC sys.sp_cdc_enable_table
    @source_schema = $TABLE_SCHEMA,
    @source_name   = $TABLE_NAME,
    @role_name     = NULL,
    @filegroup_name = NULL,
    @supports_net_changes = 0
GO

CREATE LOGIN changebase
    WITH PASSWORD = '$CHANGEBASE_PASSWORD';
CREATE USER changebase FOR LOGIN changebase;
GRANT SELECT ON SCHEMA :: cdc TO changebase;
GRANT EXECUTE ON SCHEMA :: cdc TO changebase;
GRANT SELECT ON SCHEMA :: dbo TO changebase;