Migrate an on-premises Microsoft SQL Server database to Amazon Redshift using AWS DMS

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.

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.