Loading
Loading articles
By Aritra Biswas

AI summary
This article outlines a secure, least-privilege configuration for using AWS Database Migration Service (DMS) for SQL Server Change Data Capture (CDC) without requiring sysadmin privileges. The approach utilizes certificate-signed wrapper procedures to interact with transaction logs and integrates AWS Secrets Manager for secure credential handling. It provides a repeatable pattern suitable for environments requiring strict separation of duties.
Key points