Services upgrade overview for SharePoint Server 2019
APPLIES TO: 2013 2016 2019 Subscription Edition SharePoint in Microsoft 365
The upgrade process for SharePoint Server 2019 uses the database attach upgrade method. When you move your databases to a new farm and upgrade the content, you must create your services infrastructure in the new farm, and configure the services appropriately for your new farm and new version. The following service applications have databases that can be upgraded when you upgrade from SharePoint Server 2016 to SharePoint Server 2019:
Business Data Connectivity service application
Managed Metadata service application
PerformancePoint Services service application
Search service application
Secure Store Service application
User Profile service application
Word Automation Services and Machine Translation Services can't be upgraded. A new service instance needs to be created.
Attaching and upgrading these databases configures these service applications. Settings for other services will have to be reconfigured when you upgrade.
Database attach upgrade with services
You must create the service applications on your new farm before you upgrade your content databases. The steps included in the installation guide above describe how to use the Farm Configuration Wizard to enable all service applications. Some service applications can be upgraded by using a service application database upgrade. If you want to upgrade these service applications by upgrading the service application databases, you should not use the Farm Configuration Wizard to configure these service applications when you set up your new farm.
The following service applications can be upgraded by performing a services database upgrade:
Business Data Connectivity service
The Business Data Connectivity service uses a database to store information about external data. This database must be upgraded as part of a services database attach upgrade. This service application is also available in SharePoint Foundation 2013.
Managed Metadata service
The Managed Metadata service uses a database to store metadata information. This database must be upgraded as part of a services database attach upgrade. You must attach and upgrade the database for this service and for the User Profile service before you can upgrade any My Sites.
PerformancePoint Services use a database to store information. This database must be upgraded as part of a services database attach upgrade.
Secure Store service
The Secure Store Service uses a database to store information. This database must be upgraded as part of a services database attach upgrade. You have to upgrade the data for this service application so that any connections from Excel Services Application and Business Connectivity Services can work with existing passwords.
User Profile service
The User Profile service uses databases to store profile, social, and sync information. These databases must be upgraded as part of a services database attach upgrade. You have to attach and upgrade the databases for this service and for the Managed Metadata service before you can upgrade any My Sites.
The Search service uses several databases. The search administration database stores search configuration data, such as the topology, crawl rules, query rules, and the mappings between crawled and managed properties. The analytics reporting database stores the results of usage analytics and statistics information from the analyses.
The search administration database must be upgraded as part of a services database attach upgrade, and you can optionally upgrade the analytics database as part of the services database attach upgrade. You have to attach and upgrade the database for the User Profile service and Managed Metadata service before you upgrade the search databases. You cannot use the database attach approach for the rest of the search databases, these databases are re-created when you upgrade the Search service application.
Specifically, the following service application databases can be upgraded:
|Service application||Default database name|
|Business Data Connectivity
||Managed Metadata Service_<GUID>
||PerformancePoint Service Application_<GUID>
|User Profile: Profile and Social databases
||User Profile Service Application_ProfileDB_<GUID>
User Profile Service Application_SocialDB_<GUID>
User Profile Service Application_SyncDB_<GUID>
The steps to upgrade these service application databases are included in Upgrade service applications to SharePoint Server 2019.
Considerations for specific services
The following services in SharePoint Server 2016 also require additional steps to enable and configure when you upgrade:
InfoPath Forms Service
This service is not part of the Farm Configuration Wizard. If you want to use this service, you can use the Configure InfoPath Forms Services link on the General Application Settings page in SharePoint Central Administration to configure it. If you want to continue using form templates from your previous environment, you can export any administrator-deployed form templates (.xsn files) and data connection files (.udcx files) from your SharePoint Server 2016 environment, and then import them to your new SharePoint Server 2019 environment by using the Export-SPInfoPathAdministrationFiles PowerShell cmdlet. If the URL of the new server differs from the URL of the previous server, you can run the Update-SPInfoPathAdminFileUrl PowerShell cmdlet to update links that are used in the upgraded form templates.
Overview of the upgrade process to SharePoint Server 2019