Update strings table and environment

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