Project Renamer alternatives

[AZ]

I have installed the Project Renamer, following all instructions, but the
application does not populate with any projects in PWA (althought it appears
to connect properly to the PWA site). First question: is there a way to
resolve this? I have registered the DLL, made the registry change, and logged
in as admin, all to no avail.

Secondly, can I rename projects directly in the database? I am nervous about
doing this, as I am not sure what else it may effect (ie. SharePoint
Issue/Documents sites?).

Any help would be appreciated

 

[Dean Beckley]

I wrote some tsql to do this directly to the DB. It updates Project Server
and Sharepoint. I've run it half a dozen times in a production environment
without any issues.

I'll paste it below. I'd love to hear from anyone if I've got it right.

Dean

/* This query updates a project name in Project Server 2003. Type in the
Old Name and New Name,
thenrun the query. This will update tables in the ProjectServer and
Sharepoint Sites Databases*/

declare @OldName varchar(30)
declare @NewName varchar(30)

set @OldName = 'OLDNAME' --Enter Old Name Here
Print 'Set @OldName = '+@OldName
set @NewName = 'NEWNAME' --Enter New Name Here
Print 'Set @NewName = '+@NewName


update ProjectServer.dbo.MSP_Cube_Projects set proj_name =
@NewName+'.Published' where proj_name = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_Cube_Projects.proj_name Updated'
update ProjectServer.dbo.MSP_Projects set proj_name = @NewName+'.Published'
where proj_name = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_Projects.proj_name Updated'
update ProjectServer.dbo.MSP_Projects set proj_project = '<>\'+@NewName
where proj_project = '<>\'+@OldName
Print 'ProjectServer.dbo.MSP_Projects.proj_project Updated'
update ProjectServer.dbo.MSP_Projects set proj_prop_title =
@NewName+'.Published' where proj_prop_title = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_Projects.proj_prop_title Updated'
update ProjectServer.dbo.MSP_Tasks set task_name = @NewName+'.Published'
where task_name = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_Tasks.task_name Updated'
update ProjectServer.dbo.MSP_VIEW_PROJ_PROJECTS_ENT set
ProjectEnterpriseName = '<>\'+@NewName where ProjectEnterpriseName =
'<>\'+@OldName
Print 'ProjectServer.dbo.MSP_VIEW_PROJ_PROJECTS_ENT.ProjectEnterpriseName
Updated'
update ProjectServer.dbo.MSP_VIEW_PROJ_PROJECTS_STD set ProjectTitle =
@NewName+'.Published' where ProjectTitle = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_VIEW_PROJ_PROJECTS_STD.ProjectTitle Updated'
update ProjectServer.dbo.MSP_VIEW_PROJ_TASKS_STD set TaskName =
@NewName+'.Published' where TaskName = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_VIEW_PROJ_TASKS_STD.TaskName Updated'
update ProjectServer.dbo.MSP_WEB_ASSIGNMENTS set TASK_NAME =
@NewName+'.Published' where TASK_NAME = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_WEB_ASSIGNMENTS.TASK_NAME Updated'
update ProjectServer.dbo.MSP_WEB_PROJECTS set PROJ_NAME = @NewName where
PROJ_NAME = @OldName
Print 'ProjectServer.dbo.MSP_WEB_PROJECTS.PROJ_NAME Updated'
update ProjectServer.dbo.MSP_Web_Projects set WLOCAL_PATH =
'<>\'+@NewName+'.Published' where WLOCAL_PATH = '<>\'+@OldName+'.Published'
Print 'ProjectServer.dbo.MSP_Web_Projects.WLOCAL_PATH Updated'
update ProjectServer.dbo.MSP_WEB_WORKGROUP_FIELDS set VARCHAR_VAL =
@NewName+'.Published' where VARCHAR_VAL = @OldName+'.Published'
Print 'ProjectServer.dbo.MSP_WEB_WORKGROUP_FIELDS.VARCHAR_VAL Updated'
update WSS_Projects_Content.dbo.Webs set title = @NewName where title =
@OldName
Print 'WSS_Projects_Content.dbo.Webs.title Updated'