Best way to migrate SharePoint Workflow Manager Databases

Question

Here is a scenario that I would like to know best way to tackle it.

1. SharePoint 2013 Farm 5 servers (2 app, 2 web, 1 DB) -- Windows Server 2012
2. Workflow Manager Server (a standalone box) -- Windows Server 2012
3. Workflow Manager DB Server (a SQL shared box) -- Windows Server 2008

As part of the infrastructure upgrade - we are decommissioning Windows 2008 servers. I was told to move workflow manager databases out of Windows 2008.

What I found online are the articles pointing to WFM disaster recovery plan where we backup restore workflow DBs onto a different server, re-install workflow manager on a new server, and execute the WFM restore using PowerShell.

Without doing Workflow Manager installation or uninstall/re-stalling, is there a way (even possibility) to migrate just the 6 workflow databases to different DB server, and then update existing workflow manager DB connection strings?

question from:https://stackoverflow.com/questions/65923608/best-way-to-migrate-sharepoint-workflow-manager-databases

Answer 1

Waitting for answers