AWS Prescriptive Guidance
Patterns

Downgrade Microsoft SQL Server on Amazon RDS from Enterprise to Standard edition

R Type :RePlatform

source :Databases: Relational

target :Amazon RDS for Microsoft SQL Server

tags :amazon rds, microsoft sql server, microsoft sql server managemnet studio (ssms)

Summary

This pattern describes how to determine whether you can downgrade from Microsoft SQL Server Enterprise edition to Standard edition on Amazon Relational Database Service (Amazon RDS) to reduce costs.

There are multiple migration paths for reducing SQL Server licensing costs, but this simple process provides a quick win. By using the SQL statement provided in this pattern, you can quickly check whether your Microsoft SQL Server on Amazon RDS edition is a downgrade candidate.

Assumptions and Prerequisites

Prerequisites

  • You have access to SQL Server using SQL tools, for example, Microsoft SQL Server Management Studio (SSMS)

  • The Microsoft SQL Server login user has VIEW DATABASE STATE permissions

  • The Microsoft SQL Server version is SQL Server 2008 through SQL Server 2016

Architecture

Source and target technology stacks

  • Amazon RDS for Microsoft SQL Server (Enterprise edition and Standard edition)

Source and target technology architecture

You can use the following SQL statement to determine whether your Amazon RDS for Microsoft SQL Server database is using Enterprise edition-specific features:

SELECT feature_name FROM sys.dm_db_persisted_sku_features; GO

If the view returns no rows, as shown in the following screen illustration, your SQL Server database can be a candidate for downgrading from Enterprise edition to Standard edition. 

Tools Used

SSMS - Microsoft SQL Server Management Studio (SSMS) is an integrated environment for managing SQL Server infrastructure. It provides a user interface and a group of tools with rich script editors that interact with SQL Server.

Epics

Validate SQL Server Enterprise edition feature usage

Tasks

Title Description Skills Predecessor
Run a SQL query against SQL Server to determine Enterprise feature usage. Determine Enterprise edition-specific feature usage by running this SQL query: SELECT feature_name FROM sys.dm_db_persisted_sku_features; DBA, Developer

References and Help

References

Contact and help

Migration Pattern Library Support: aws-mpl@amazon.com