How do I assess my on-premise SQL Server database for readiness to AWS RDS for SQL Server migration?

0

How do I assess my on-premise SQL Server database for readiness to AWS RDS for SQL Server migration?

  • Is there a SAMPLE assessment report I can take a look highlighting SAMPLE remediations?

2개 답변
1

You can consider using AWS Database Migration Service (AWS DMS) to migrate your data. Take a look at DMS Fleet Advisor which collect metadata and performance metrics and generates right-sized target recommendations.

Considerations and approaches can be found in DMS's Step-by-Step Migration Guide for SQL Server

AWS
전문가
Mike_L
답변함 10달 전
profile picture
전문가
검토됨 10달 전
  • Is there something equivalent of Azure Data Studio > Assessment as mentioned on this link - https://learn.microsoft.com/en-us/sql/dma/dma-assesssqlonprem?view=sql-server-ver16. Say, I have 50 databases to be migrated, I want to perform assessment and notify respective Application team about remediation required. Plan for actual migration once I see assessment report shows ALL GREEN and then cut over comes.

  • Thanks for clarification. I have updated original post to include DMS Fleet Advisor

0

I would suggest running the AWS SCT Reports for SQL Server and see if AWS RDS SQL Server does not support any of the on-premises features then you can decide on RDS/EC2.

답변함 7달 전

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

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

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