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

已提问 1 年前93 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则