Can I create Redshift as Source Endpoint in DMS?

Hi,

You have here the full list of supported source endpoint for DMS: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html#CHAP_Introduction.Sources.DataMigration

Redshift is not part of them: you cannot use DMS for your use case.

However, if you use AWS Glue with its ETL features (see https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html#CHAP_Introduction.Sources.DataMigration), you can connect to RedShift extract your data and load it into SQl Server.

Best,

Didier

There is no direct way to use Redshift as DMS source endpoint. You can export data from Redshift to say s3 and then use it as dms source https://docs.aws.amazon.com/redshift/latest/dg/t_Unloading_tables.html