question

AAL-2122 avatar image
0 Votes"
AAL-2122 asked AAL-2122 commented

Move Workflow Manager databases from SQL Server 2016 to SQL Server 2019

Hi,

We are using Sharepoint 2019 and we want to migrate our Workflow Manager SQL databases from SQL Server 2016 (Always On) to SQL Server 2019 AO (The workflow manager servers are not migrated and remain the same).
Will the databases restored on SQL Server 2019 be compatible with our following current configuration? :
- Workflow Manager 1.0 (CU5) - KB4055730 (v. 2.0.40131.0)
- Service Bus 1.1 - KB3086798 (v. 2.0.30904.0)

Also, we used SQL aliases to reference databases on WF Manager. Are the following actions sufficient to change SQL Server ? :
- Stop the WF and SB services on WF Manager servers
- Restore databases on SQL Server 2019
- Change the SQL ALIAS to point to the new SQL Server
- Restart WF and SB services

Thanks for your help!

office-sharepoint-server-administrationsharepoint-workflow
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

UmrF avatar image
0 Votes"
UmrF answered AAL-2122 commented

This will work fine how ever in SP 2019 version number for SB1.1 is 2.0.50926.9.
- Workflow Manager 1.0 (CU5) - KB4055730 (v. 2.0.40131.0)
- Service Bus 1.1 - KB3086798 (v. 2.0.30904.0)

you need to restore the database ( not all of them just few that shows up in the configuration wizard of WF manager).
Install service bus and WFM bits (if using TLS 1.2).
Run the WFM configuration wizard with the restored database names.
Make sure services are running.

Easy to perform all steps on a single server. Make sure single server farm is working and then add additional farm member in case you have 3 server farm.
HTH.

· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your reply,
However I don't want to reinstall WF Manager and Service bus because I keep existing servers where they are installed. Only SQL databases will have to be moved to a new SQL 2019.
Do I still have to reinstall WFM et SB ?? I just have to change SQL ALIAS to point to the new SQL Server so it finds the associated database right ?
Thanks.

0 Votes 0 ·

If you are keeping the same WF servers. no need to reinstall. Just point the SQL alias to the new SQL server, make sure permissions are same as on previous instance and it should be good.

1 Vote 1 ·

@AAL-2122 ,

Is there any update on this thread?

0 Votes 0 ·

Thanks for your reply,
On the following article about Workflow Manager CU5, SQL Server 2019 is not mentioned (only SQL 2017 is indicated). Is Workflow Manager supported by Microsoft on SQL Server 2019?
https://support.microsoft.com/fr-fr/topic/description-de-la-mise-%C3%A0-jour-cumulative-5-pour-le-gestionnaire-de-workflow-1-0-7631b4c0-b3d7-644c-fcd9-671f10cfc0bb
Thank you

0 Votes 0 ·
Show more comments