Point to new sql instance

Prior to this you most have backuped and moved the database to the new location

It is highly recommended to use alias for sql connection

You also have to update Service Bus and Workflow Manager if you move those databases as well

1. First you have to stop all system running for Zervicepoint

   Stop-SBFarm -Verbose
   Stop-WFHost -Verbose
   
   Stop-Service -Name ProcessSystem, ProvisioningSystem, ProvisioningSystemInventory, W3SVC -Verbose
   

2. You need to update the following configurations files in order to get Zervicepoint to connect to the new instance

   C:\Program Files\Zipper\ZervicePoint\ProcessSystem\Zipper.ZervicePoint.ProcessSystem.WorkflowService.exe.config
   

   C:\Program Files\Zipper\ZervicePoint\Web\AdminWeb\Web.config
   

   C:\Program Files\Zipper\ZervicePoint\Web\ProcessSystem\Web.config
   

   C:\Program Files\Zipper\ZervicePoint\Web\UserWeb\Web.config
   

   C:\Program Files\Zipper\ZervicePoint\Web\WebApi\Web.config
   

3. After you performed the change on these files it is time to start up all systems again

   Start-Service -Name W3SVC, ProcessSystem, ProvisioningSystem, ProvisioningSystemInventory -Verbose
   
   Start-WFHost -Verbose
   Start-SBFarm -Verbose