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 個月前

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

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

回答問題指南