When Amazon RDS supports a new version of a database engine, you can upgrade your DB instances to the new version. There are two kinds of upgrades for SQL Server DB instances: major version upgrades and minor version upgrades.
Major version upgrades can contain database changes that are not backward-compatible with existing applications. As a result, you must manually perform major version upgrades of your DB instances. You can initiate a major version upgrade by modifying your DB instance. However, before you perform a major version upgrade, we recommend that you test the upgrade by following the steps described in Testing an RDS for SQL Server upgrade.
Minor version upgrades contain only changes that are backward-compatible with existing applications. You can upgrade the minor version for your DB instance in two ways:
-
Manually – Modify your DB instance to initiate the upgrade
-
Automatically – Enable automatic minor version upgrades for your DB instance
When you enable automatic minor version upgrades, RDS for SQL Server automatically upgrades your database instance during scheduled maintenance windows when critical security updates are available in a newer minor version.
For minor engine versions after 16.00.4120.1
, 15.00.4365.2
, 14.00.3465.1
, 13.00.6435.1
,
the following security protocols are disabled by default:
rds.tls10
(TLS 1.0 protocol)rds.tls11
(TLS 1.1 protocol)rds.rc4
(RC4 cipher)rds.curve25519
(Curve25519 encryption)rds.3des168
(Triple DES encryption)
For earlier engine versions, Amazon RDS enables these security protocols by default.
...
"ValidUpgradeTarget": [
{
"Engine": "sqlserver-se",
"EngineVersion": "14.00.3281.6.v1",
"Description": "SQL Server 2017 14.00.3281.6.v1",
"AutoUpgrade": false,
"IsMajorVersionUpgrade": false
}
...
For more information about performing upgrades, see Upgrading a SQL Server DB instance. For information about what SQL Server versions are available on Amazon RDS, see Amazon RDS for Microsoft SQL Server.
Topics
Upgrading a SQL Server DB
instance
For information about manually or automatically upgrading a SQL Server DB instance, see the following:
Important
If you have any snapshots that are encrypted using AWS KMS, we recommend that you initiate an upgrade before support ends.
Upgrading deprecated DB
instances before support ends
After a major version is deprecated, you can't install it on new DB instances. RDS will try to automatically upgrade all existing DB instances.
If you need to restore a deprecated DB instance, you can do point-in-time recovery (PITR) or restore a snapshot. Doing this gives you temporary access a DB instance that uses the version that is being deprecated. However, after a major version is fully deprecated, these DB instances will also be automatically upgraded to a supported version.