SQL Database?

[Graham K]

Hi, Is there a way of moving saved and publised projects from an old project
server 2007 box to another new project server 2007 with a fresh install. All
the migration tools talk from 2003 to 2007 but i want to know is there any
way to do it from 2007 to 2007?

 

[Andrew Lavinsky]

Option 1) Just backup the dbs and move them over to your new SQL server.
Provision the new PWA instance with those databases.

The question comes up though with the workspace data. If you don't need
to move that over, life is simple. If you do move it over, you'll need to
identify the content db it's in, reattach it to the new farm, and relink
the projects to the sites.

Option 2) From Central Admin, do a full farm backup. Then do a full farm
restore in the target environment.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm