Home icon

Configure change data capture parameters on Amazon RDS for SQL Server

Database Blog

This article discusses how to configure change data capture (CDC) parameters on Amazon RDS for SQL Server when using AWS Database Migration Service (AWS DMS). It explains the importance of enabling CDC for AWS DMS to work with RDS for SQL Server, and provides guidance on tuning CDC parameters like max_trans, max_scans, and polling_interval.

Specifically, the article covers:

  • How AWS DMS works with Amazon RDS for SQL Server and the need for CDC
  • Understanding CDC parameters like max_trans, max_scans, continuous, polling_interval, and retention
  • Configuring and monitoring CDC parameters with examples
  • Best practices for handling planned failovers, maintenance, and failover scenarios
  • Troubleshooting issues like transaction log truncation and missed log sequence numbers
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jul 15
2025
Amazon RDS Custom for SQL Server now supports change data capture
May 24
2024
Choose the right change data capture strategy for your Amazon DynamoDB applications
Dec 10
2024
Amazon RDS for SQL Server Supports new custom parameters for native backup and restore
Jun 16
2025
Native SQL Server replication options on Amazon RDS Custom for SQL Server

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.