- 新しい順
- 投票が多い順
- コメントが多い順
Hi,
Using schema-binding or non-schema binding views as a data source in SQL Server is just supported for full-load only tasks.
Here's the full list of limitations on using SQL Server as a source in DMS https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Limitations
Regards,
You are only able to perform a Full Load from a view in SQL Server. I know with Oracle you can perform CDC from a materialized view but I do not know if that has been tested with SQL Server.
回答済み 4年前
Views do not have Primary Key (PK). Those keys are crucial for change data capture (CDC) to identify changes to rows. Due to non existence of primary keys CDC from views is not supported in DMS. You will need to convert to physical table with appropriate PKs. And depending on frequency of change to your base table data refresh these new tables and then run DMS CDC on them.
