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 Antworten
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
EXPERTE
Mike_L
beantwortet vor 10 Monaten
profile picture
EXPERTE
überprüft vor 10 Monaten
  • 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.

beantwortet vor 7 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen