How to automate an in-place upgrade of SQL Server on Amazon EC2
Microsoft Workloads on AWS Blog
This article provides a step-by-step guide on how to automate an in-place upgrade of SQL Server instances running on Amazon EC2 to newer versions like SQL Server 2016, 2017, 2019, or 2022. It covers the prerequisites, one-time setup steps, and the process of running the custom automation document to perform the upgrade.
Specifically, the article covers:
- Prerequisites (S3 bucket, space on EC2 instance, Systems Manager Agent, SQL Server Management Studio access)
- One-time setup steps (creating custom document, uploading SQL Server binaries to S3, setting up AWS Secrets Manager secret, attaching IAM role to EC2 instance, confirming instance is listed in Fleet Manager)
- Using the custom document (running the document, entering parameters, performing pre-checks, optional database backups, validating results, applying latest updates)
- Conclusion and cleanup steps
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
2024
2024
2024
2026
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.