Renaming Projects in Database

K

Kevin Flanagan

A few weeks back I had posted a question on how to rename
projects using the database so that I did not loose
history on projects. Here is an update:

I renamed them in MSP_PROJECTS, MSP_WEB_PROJECTS and
MSP_VIEW_PROJ_PROJECTS_ENT

What I am seeing now is this:

I can open a renamed project. However when I try to
save, the SaveAs dialog opens and says that I cannot save
the file because it is opene in another session. Then
when I go into the database there are two files with the
same name. Any help appreciated because I really need to
do this in production for two users and their VP.

Thanks,

Kevin
 
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.
 
K

Kevin Flanagan

I did go out and delete. The issue was all the child
(version) plans. They had to be saved off as well,
before I could delete the published version. I also had
to go through some of the tables in the database because
one file did not clean up well and left many redcords
behind.

Kevin
-----Original Message-----
Do a search in groups.google.com for the
Click to expand...
following "Change project name -
 
E

Evgeniy

Some time ago I found similar answer to this question.
I have no idea why not to simply:
1. Open the project to be renamed.
2. Save in with the name you need.
3. Remove the project with obsolete name using PWA.
Regards.
Evgeniy.
 
Top