Change Web Services for Microsoft Dynamics GP Web Server Location In All Companies

Microsoft Dynamics GPIn the last post, I posted a script to find which Microsoft Dynamics GP company databases had web services enabled. Todays script is a related one; it can be used to change the web services server location in all companies.

This script was created so once a live system was copied to a standalone test system, the web services server can easily be updated to the test server.

The highlighted section is the new server location which should be set:

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
DECLARE @SQL NVARCHAR(MAX) SET @SQL = STUFF(( SELECT CHAR(13) + 'UPDATE WF SET Web_Service_Server = ''test.example.co.uk'' FROM ' + INTERID + '.dbo.WF00100 AS WF' FROM DYNAMICS.dbo.SY01500 FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '') EXEC sys.sp_executesql @SQL