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

AAL 21 Reputation points
2021-09-09T13:28:52.553+00:00

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!

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
569 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,936 questions
0 comments No comments
{count} votes

Accepted answer
  1. Umr 521 Reputation points
    2021-09-09T14:33:23.743+00:00

    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.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.