yes, it is the right tool.
More information about you want to achieve here: https://aws.amazon.com/premiumsupport/knowledge-center/dms-migrate-rds-sqlserver/.
You are able to use MSSQL on RDS as source on DMS: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html
And you are able to use a MSSQL on EC2 instance as target on DMS: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.html
Just check that your MSSQL version is supported.
SQL Server RDS migration to EC2 SQL ServerAccepted Answerasked 6 months ago
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 7 months ago
About DMS migration from ms-sql to dynamodbasked 6 months ago
We have multiple sql server databases on premises and those are setup as clusters, now we have decided to migrate same in RDS, ow how to migrate clustersasked 4 months ago
How to take backup of sql server on Another windows machineasked 3 months ago
Migrate SQL Server 2008/2012 to AWSasked a month ago
DMS to migrate SQL Server from RDS to EC2asked 3 years ago
How to migrate relational data from a relational SQL DB to NoSQL DB with DMSasked 3 months ago
Migrate SQL Server DB (outside of AWS) to Aurora DB in AWSAccepted Answerasked 4 months ago
Data Base Migration from On Prem My SQL Server to AWS RDS using DMSasked 7 months ago