Renaming Projects in SQL

K

Kevin Flanagan

I need to change a project name once it has been
published to the server. I know if I rename and
republish, I will lose all of the version information
that is currently oon file. Since projects are tracked
by PROJ_ID, can I just change the name in the database
and have everything still track OK?

Kevin
 
L

Leo

Kevin,
you have to rename some tables :
MSP_VIEW_PROJ_PROJECTS_ENT
MSP_WEB_PROJECTS
MSP_PROJECTS

where in some tables there will be more than 1 field that have to rename.

After that, you have to rebuild your OLAP Cube...
Hope this help, and pls let me know the status again.
 
D

David Gage - Project MVP

Do a search in groups.google.com for the following "Change project name -
solution group:microsoft.public.project.pro_and_server".

It is not so easy as renaming some items since Project Pro keeps track of
certain things within the Binary Reserved Data. The main thing to
understand is that when you rename a project and publish it that it creates
a second entry with a different timestamp. The timestamp is what Project
Server keys off of for showing projects.

Another way to do this is to save the project as a file, delete the project
from Project Server, and import the project. Hope that helps.

David
 
Top