Update service application database in Sharepoint 2016.

Question

Experts,
I have already created and configured sharepoint 2016 service application (search service, managed metadata service, user profile service etc..) but already I have these service application ups and running in sharepoint 2013 environment. So how do I Migrate these database to sharepoint 2016 service application.. I have seen many open forums, they are saying create new SA and configure the upgraded SA DB to it. Since already I have created the SA and configured SA db in SP2016... so how can I update service application database or something better approach???? Your input and help is appreciated.
Thanks,
Rahul

Nanddeep Nachan · Accepted Answer

For Search Service Application , use Set-SPEnterpriseSearchServiceApplication Documentation here: https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/set-spenterprisesearchserviceapplication?view=sharepoint-ps

Nanddeep Nachan · Answer

Please note,  Upgrade User Profile service application and Managed Metadata service application before you upgrade Search service application.

Nanddeep Nachan · Answer

For User Profile Service Application , use Set-SPProfileServiceApplication Documentation here: https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/set-spprofileserviceapplication?view=sharepoint-ps

Nanddeep Nachan · Answer

For Managed Metadata service , use Set-SPMetadataServiceApplication Documentation here: https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/set-spmetadataserviceapplication?view=sharepoint-ps

Rahul Khanna · Answer

In the example,they are creating the new service application and passing the upgraded database name as parameter... but in my case already I have created service application want to update service application with "upgraded db" how can I do this.... Is there any update command???

Nanddeep Nachan · Answer

Please use the ready PowerShell here to upgrade service applications https://docs.microsoft.com/en-us/sharepoint/upgrade-and-update/upgrade-service-applications-to-sharepoint-server-2016

Rahul Khanna · Answer

Thanks for your reply... that's my plan but actually map the upgraded database... can you please give an example.

Nanddeep Nachan · Answer

If you have not started using the service applications in SP2016 yet then upgrade the SA DBs from SP2013 to SP2016 and point your SAs to those DBs.