连接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
用心对待身边的一切,一切皆有可能!