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

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?

  • wilson
    a year ago

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

Topics
Migration & ModernizationDatabaseAnalytics
Tags
AWS Database Migration ServiceMicrosoft SQL ServerAmazon Relational Database Service
Language
English
wilson
asked a year ago460 views
2 Answers
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
EXPERT
MikeLim
answered a year ago
profile picture
EXPERT
Riku_Kobayashi
reviewed a year ago
  • wilson
    a year ago

    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.

  • MikeLim EXPERT
    a year ago

    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.

Sanjeev_K
answered a year ago

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