| title | Complete the Database Engine Upgrade |
|---|---|
| description | This article describes some extra steps you might have to take after you finish upgrading the Database Engine of SQL Server. |
| author | rwestMSFT |
| ms.author | randolphwest |
| ms.date | 06/03/2025 |
| ms.service | sql |
| ms.subservice | install |
| ms.topic | upgrade-and-migration-article |
| monikerRange | >=sql-server-2016 |
[!INCLUDE SQL Server -Windows Only]
After upgrading the [!INCLUDE ssDE], complete the following tasks:
-
Back up your databases:
Perform a full backup of each database.
-
Enable new features:
In [!INCLUDE sssql16-md] and later versions, some changes are only enabled once the
DATABASE_COMPATIBILITYlevel for a database is changed to 130 or greater. For more information and for the recommended workflow, see Change the database compatibility level and use the Query Store. If your database has memory-optimized tables created in [!INCLUDE sssql14-md], review Statistics for Memory-Optimized Tables. -
Integration Services:
Migrate Integration Services packages to the latest format. For more information, see Upgrade Integration Services Packages.
-
Reporting Services:
For a new installation upgrade, restore the Reporting Services encryption Keys. For more information, see Back up and restore SQL Server Reporting Services (SSRS) encryption keys.
-
Master Data Services:
Upgrade the Master Data Services (MDS) database schema and create the [!INCLUDE sssql19-md] web application. For more information, see Upgrade Master Data Services.
[!NOTE]
MDS is discontinued in [!INCLUDE sssql25-md]. -
Data Quality Services:
Upgrade the Data Quality Services (DQS) databases schema and verify the DQS databases schema upgrade. For more information, see Upgrade Data Quality Services.
[!NOTE]
DQS is discontinued in [!INCLUDE sssql25-md]. -
Full Text Search:
Repopulate full-text catalogs to ensure semantic consistency in query results. For more information, see Populate Full-Text Indexes.