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...

질문됨 일 년 전93회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠