Migration of OneDrive from Sharepoint 2019 to Sharepoint Subscription Edition

[noorulahmed]

Hi There,

I want to migrate sharepoint 2019 to sharepoint subscription edition. In the Microsoft documentation for database detach method of migration, it is written that all databases must be of version 16.0.4351.1000 or higher. However, sharepoint subscription edition supports SQL Server 2019 with CU 5 or higher. So, my Sharepoint Subscription Edition environment and my Sharepoint 2019 environment is on SQL Server 2019. So, how can I perform the migration? When I try to follow the steps written in upgrade instructions, the step on service application (UPS) 

New-SPProfileServiceApplication -Name '<UserProfileApplicationName>' -ApplicationPool $applicationPool -ProfileDBName '<ProfileDBName>' -SocialDBName '<SocialDBName>' -ProfileSyncDBName '<SyncDBName>'

stalls and the command just stays without throwing any error. The User Profile Service is in the "starting" state and it fails with an exception when clicked. The  Database version requirements for Subscription edition clearly states that it supports SQL Server 2019 CU5 and above as stated here. Can you please advise how can I perform the migration in such case?

[#2]

I recommend you updating your SharePoint Enviroment to the latest CU and same with the SQL and then doing the upgrade!

[#3]

Hi, I managed to solve this issue. I was taking the DB backup using the source farm admin user and restoring the DB in the destination server using the destination farm admin user. I added the destination farm admin user as sysadmin and db_owner in the source farm datbase server and used that login to take the backup. It worked in this way.