By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

AWS DMS Fleet Advisor

0

I have set up the DMS fleet advisor and ran the recommendations for the SQL server. It gave me Target recommendations. but I have confused about target recommendations.

  1. Initially I ran the recommendations for SQL server without SQL Agent jobs and linked server and Server credentials - The target recommendation is an RDS SQL server - I agree with this

  2. Second, I have created the SQL jobs and Linked server and credentials on the same server and I reran the recommendations and gave the recommended target as RDS again but, it should give the EC2 with SQL server, right ( SQL jobs and server credential and Linked server not supported in RDS SQL Server)

Can you please let me know why DMS is recommending the RDS instead of EC2? does DMS provide recommendations based on databases or servers?

Topics
Migration & ModernizationDatabase
Tags
AWS Database Migration ServiceMicrosoft SQL ServerDatabaseSQL Migrations
Language
English
Sanjeev_K
asked a year ago272 views
1 Answer
1

SQL Agent jobs, server credentials and Linked servers are all supported features of RDS so, based on this alone, the recommendation is correct.

If AWS DMS Fleet Advisor identifies database features in use where Amazon Relational Database Services (Amazon RDS) limitations may exist, it should provide prescriptive guidance on what is required for migration (see here).

AWS
adrian-AWS
answered a year ago
  • rePost-Sanjeev
    a year ago

    Thanks for update,

    if suppose, On-premises SQL server using File stream and Server level triggers than, will DMS fleet advisor recommend the EC2 instance as target.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content