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 데이터베이스 마이그레이션 서비스마이크로소프트 SQL 서버데이터베이스SQL 마이그레이션
언어
English
Sanjeev_K
질문됨 일 년 전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
답변함 일 년 전
  • rePost-Sanjeev
    일 년 전

    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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠