Posted On: Jun 14, 2022

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports TDE enabled database migrations using Native Backup/Restore for Microsoft SQL Server. Previously, you would need to disable TDE on your on-premises TDE enabled SQL Server database in order to migrate to Amazon RDS. 

Now you can migrate the backup files of your on-premises database without disabling TDE. You will be able to take a backup of your existing TDE certificate, store it in Amazon S3, and restore it to an existing Amazon RDS instance with the TDE option enabled. From there, you can follow the existing procedures to export a full backup of your on-premises TDE enabled database, store it in Amazon S3, and restore that backup to your Amazon RDS instance directly using the custom stored procedures offered by Amazon RDS. This feature is available for Amazon RDS for SQL Server Single-AZ instances.

Please visit the Amazon RDS for SQL Server User Guide to learn more.

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details in Amazon Web Services China (Beijing) Region, operated by Sinnet, and Amazon Web Services China (Ningxia) Region, operated by NWCD.