Support for CDC on Azure SQL Database sources

0

The document at https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.AzureSQL.html says:

"AWS DMS doesn't support change data capture operations (CDC) with Azure SQL Database.",

but the release notes for DMS version 3.4.7 at https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReleaseNotes.html#CHAP_ReleaseNotes.DMS347 says:

"For RDS SQL Server, Azure SQL Server, and self-managed SQL Server — DMS now provides automated setup of MS-CDC on all tables selected for a migration task that are with or without a PRIMARY KEY"

Is the "Azure SQL Server" part referring to Azure SQL Database, or Azure SQL Managed Instance? I'm presuming the latter. When I did try to do a full load and incremental load I got somewhat cryptic message implying that Azure SQL Database is NOT able to do incremental loads with CDC (as the first doc I linked to says).

If that is the case, does anyone know why Azure SQL Database is not supported, even though Azure SQL Database itself supports CDC? At this point in my investigation of database migration services (of any flavour) I would love it to be supported...

asked a year ago93 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions