Prerequisites and limitations - AWS Prescriptive Guidance

Prerequisites and limitations

Prerequisites

  • No application support requirements for SQL Server Enterprise edition

  • An active AWS account

  • Secure network connectivity, through a virtual private network or AWS Direct Connect, between your on-premises data center and a virtual private cloud (VPC) on AWS

  • SQL Server Enterprise edition running in an on-premises data center or on an Amazon Elastic Compute Cloud (Amazon EC2) instance or on Amazon RDS for SQL Server

  • A database client tool, such as SQL Server Management Studio (SSMS), for running Transact-SQL (T-SQL) commands

  • Database user account with appropriate permissions for running AWS Schema Conversion Tool (AWS SCT) assessment

Limitations

  • Amazon RDS for SQL Server has storage size and IOPs limits. For the current maximum, see the AWS documentation.

  • AWS SCT supports SQL Server version 2008 and later.

Product versions

The general logic described in this guide applies to SQL Server versions from 2005 and later. However, AWS SCT supports only SQL Server versions 2008 and later. To identify feature usage in cases where AWS SCT is not supported, run SQL queries on the source database.

For a current list of supported versions and editions, see Microsoft SQL Server on Amazon RDS in the AWS documentation. For details on pricing and supported instance classes, see Amazon RDS for SQL Server pricing.