Detailed Demo - AWS DMS for Data Migration in Redshift from SQL Server

[@Explore_with_Azizul-maqsud]

great. Subscribed. ty

[@flodemonnn]

great video! thanks this was helpful

[@MyNameisRohan1]

Hi Vishwaraj, What would change in this solution if the source was OnPrem SQL instead of AWS RDS? Curious to see the thought process, thank you mate!

[@Darthpiro]

What exact permissions does the DMS user connecting to redshift needs? I don't want to use the dba/superuser

[@vipulkumargupta4111]

hey, I created a private replication instance and redshift as the target endpoint. They both are in the same account and VPC. But the test connection is failing. (It was successful when the replication instance was public). Getting this error: Test Endpoint failed: Application-Status: 1020912, Application-Message: N/A, Application-Detailed-Message: N/A

[@gosco3646]

Brilliant.....👍

[@CodeVeda]

Thanks for the video. How you choose the storage for Replication instance? Is it based on the size of the log files been created?

[@vishwarajgupta1963]

Yes, depends on your data which you are going to migrate plus cache storage doesnt take much space. For eg for 1 tb data 50 gib is enough.

[@mdniyazsonu4]

Aap jo jaante ho wo bata rhe ho ke main itna jaanta hu ya dusro ko sikhaane ke lye bata rhe ho. 👎🏻