Automate SQL Server Developer Edition Deployments on Amazon RDS
This post details an automated approach for deploying Microsoft SQL Server Developer Edition on Amazon RDS, addressing the manual steps previously required. The solution uses an AWS Systems Manager Automation document to provision resources, including an S3 bucket for installation media and an RDS instance, simplifying large-scale or frequent deployments. This streamlines the process for developers and testers needing a managed SQL Server environment without additional licensing costs, leveraging RDS features like automated backups and patching.
- →Automated deployment of SQL Server Developer Edition on RDS
- →Solution architecture and automation workflow
- →Prerequisites for the automated deployment
- →Step-by-step walkthrough for deployment
Notes (4) ›
- Automated deployment of SQL Server Developer Edition on RDS
The post introduces a solution using AWS CloudFormation and Systems Manager Automation to automate the deployment of SQL Server Developer Edition on Amazon RDS. This method simplifies the process, making it repeatable and scalable, and avoids the manual steps previously required for custom engine versions (CEV).
- Solution architecture and automation workflow
The solution provisions an AWS Systems Manager Automation document via a CloudFormation stack. When executed, this document creates resources such as an S3 bucket for installation files, a temporary EC2 instance for downloading and uploading media, and the RDS for SQL Server Developer Edition DB instance itself, along with a CEV.
- Prerequisites for the automated deployment
To implement this automation, users need a VPC with subnets across different Availability Zones, a subnet with outbound internet access for the temporary EC2 instance, and an S3 bucket with a specific naming prefix (default: rds-sqldev) in the target region.
- Step-by-step walkthrough for deployment
The walkthrough guides users through creating the required S3 bucket, deploying the CloudFormation stack to create the Systems Manager Automation document, and then executing the automation runbook. It details the necessary input parameters for the automation, such as subnet IDs, S3 bucket name, and SQL Server engine version.
https://aws.amazon.com/blogs/modernizing-with-aws/automate-sql-server-developer-deployments-on-amazon-rds/
Related releases
- Amazon RDS for MariaDB Adds Support for MariaDB 12.3 LTS AWS What's New ·
- Amazon RDS shows storage volume initialization status AWS What's New ·
- Amazon Aurora Serverless Scales Faster for Bursty Workloads AWS What's New ·
- RDS SQL Server can now publish audit logs to CloudWatch AWS What's New ·
- Amazon RDS for SQL Server Developer Edition expands to 13 more AWS regions AWS What's New ·
- Amazon RDS for SQL Server adds BYOM in 10 more AWS Regions AWS What's New ·