使用 AWS re:Post 即表示您同意 AWS re:Post 使用條款
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?

主題
遷移與現代化資料庫
標籤
AWS Database Migration ServiceMicrosoft SQL Server資料庫SQL 遷移
語言
English
Sanjeev_K
已提問 1 年前檢視次數 282 次
1 個回答
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
已回答 1 年前
  • rePost-Sanjeev
    1 年前

    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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

回答問題指南

相關內容