Next steps - AWS Prescriptive Guidance

Next steps

After you determine that you can safely downgrade an instance from SQL Server Enterprise edition, the next step is to migrate to SQL Server Standard edition on Amazon RDS. To migrate the database, use one or a combination of the following tools:

  • Native backup and restore – You can use native backup and restore to move data in and out of SQL Server database instances. Amazon RDS supports native backup and restore for Microsoft SQL Server databases using full backup (.bak) files. When you use Amazon RDS, you access files stored in Amazon Simple Storage Service (Amazon S3) rather than using the local file system on the database server.

  • AWS Database Migration Service (AWS DMS) – AWS DMS helps you migrate relational databases, data warehouses, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud or between combinations of cloud and on-premises databases. The Change Data Capture option of AWS DMS offers continuous replication, so you can reduce the total downtime during migration. For information about SQL Server versions and editions that AWS DMS supports, see the AWS DMS documentation.

Depending on your availability requirements during the downgrade, you can adopt any of the following options to safely downgrade your Enterprise edition instance to a Standard edition on Amazon RDS for SQL Server.

Downgrading with downtime

  • Use native backup and restore to create a consistent copy from the Enterprise edition database and restoring to the Standard edition database.

  • Use AWS DMS to perform a full load of data from the Enterprise edition to the Standard edition database.

Downgrading with reduced downtime