Home icon

Automate SQL Server discovery and assessment to accelerate migration to AWS

Database Blog

This article discusses automating the SQL Server discovery and assessment process to accelerate migration to AWS.

Specifically, the article covers:

  • Common challenges during SQL Server migration assessment such as identifying unsupported features and sizing compute/storage resources.
  • RDSTools, a suite of PowerShell tools for SQL Server inventory, compatibility assessment, and right-sizing recommendations for Amazon RDS and AWS services.
  • RDS Discovery Tool and SQLServerAssessment Tool (SSAT) capabilities including scanning SQL Server instances, reporting unsupported features, and providing sizing recommendations based on performance metrics.
  • Post-assessment best practices like right-sizing, using ElastiCache, and consolidating instances.
  • Conclusion highlighting the benefits of automating the migration assessment process.
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jun 5
2024
How to automate an in-place upgrade of SQL Server on Amazon EC2
Aug 2
2024
Automate SQL Server deployments with AWS Launch Wizard APIs
Jan 3
2024
Migrate SQL Server databases to AWS with minimal downtime using AWS Migration Hub Orchestrator
Feb 16
2026
Accelerate your database migration journey with AI-powered AWS DMS

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.