连接tfs数据库,在对应的项目版本管理数据库查询分析器中执行如下代码

 

declare @oldServerName varchar(100)
declare @nowServerName varchar(100)
set @oldServerName='net01'  --旧服务器名称
set @nowServerName='SNET01X01' --新服务器名称

---
update tbl_Command Set IdentityName=replace(IdentityName,@oldServerName,@nowServerName)

update [Tfs_Configuration].[dbo].tbl_security_identity_cache set
--select
domain=@nowServerName,
distinguished_name=replace(distinguished_name,@oldServerName,@nowServerName),
disambiguation=replace(disambiguation,@oldServerName,@nowServerName)
where type=3