Update strings table and environment

T-SQL |

830 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

use K2;
go
 
declare @httpOld nvarchar(255) = 'http://k2workspaceuat'
declare @httpNew nvarchar(255) = 'http://k2uat'
 
declare @hostOld nvarchar(255) = 'Host=k2k2workspaceuat'
declare @hostNew nvarchar(255) = 'Host=k2uat'
 
-- update string table with new server
update  [Server].[StringTable]
set value = REPLACE(value, @httpOld, @httpNew)
where value like '%' + @httpOld + '%';
 
update  [Server].[StringTable]
set value = REPLACE(value, @hostOld, @hostNew)
where value like '%' + @hostOld + '%';
 
-- update environment table with new server
update  [Environment].[FieldValue]
set FieldValue = REPLACE(FieldValue, @httpOld, @httpNew)
where FieldValue like '%' + @httpOld + '%';
 
update  [Environment].[FieldValue]
set FieldValue = REPLACE(FieldValue, @hostOld, @hostNew)
where FieldValue like '%' + @hostOld + '%';
 
go

Pasted

Update strings table and environment

Comments