Skripte zur Umstellung der dwsystem (dwserver). Die XML-Inhalte wurden manuel mit Find/Replace geändert, weshalb das Update nur mit der Where-Bedingung auf die SID anwendbar ist:

/****** Script for SelectTopNRows command from SSMS  ******/
--update  [dwsystem].[dbo].[DWServer]
--set name = replace(name,'FRG','RGB')
--  --where sid =3

--update  [dwsystem].[dbo].[DWServer]
--set settings = '<WorkflowServer sid="3" name="WorkflowServer WTRGB-WTRGB-DW01" type="ProcessServer" guid="ece81b2e-196b-4587-9ad7-15bb4ea7c49e" active="false" description="" uid="2" portListening="9002" internalCommunication="WTRGB-DW" version="5.1.0.1" maxCopies="100" recordsInBlock="100" maxProcessCount="2" restartWorkflowsOnError="true"><IncomingCommunication><NoSecureCommunicationOptions sequenceNumber="1" communicationKind="NotSecure" /></IncomingCommunication><OutgoingCommunication><NoSecureCommunicationOptions sequenceNumber="1" communicationKind="NotSecure" /></OutgoingCommunication><SSLAuthentication /><BackupPaths><BackupPath name="Backuppfad" guid="7448774a-26b5-436c-86af-ceedc558d13f" location="D:\DW-Sicherung" /></BackupPaths></WorkflowServer>'
-- where sid =3


--update  [dwsystem].[dbo].[DWServer]
--set settings = '<AuthenticationServer sid="8" name="AuthenticationServerWTRGB-DW" type="SettingsServer" guid="51af355c-5d6e-42e8-af0a-30502fe2bc09" active="false" description="" uid="2" portListening="9000" internalCommunication="WTRGB-DW" dbConnectionGuid="2f68e729-89cf-4835-a8c4-9ec71f07df57" version="5.1.0.1" installationType="Normal"><IncomingCommunication><NoSecureCommunicationOptions sequenceNumber="1" communicationKind="NotSecure" /></IncomingCommunication><OutgoingCommunication><NoSecureCommunicationOptions sequenceNumber="1" communicationKind="NotSecure" /></OutgoingCommunication><SSLAuthentication /></AuthenticationServer>'
-- where sid =8