Project Plan backup

[Surajit Laha]

Hi,

I want to backup a single project plan and its associated timesheet
entries and then would like to restore them in a different
ProjectServer.

How can I do this in MS-Project Server 2003?

Please help.

regards,

Surajit Laha

 

[Earl Lewis]

Surajit,

This is NOT a trivial exercise, i.e. very tedious. Your individual project plan has data scattered across many tables in your project server db. You would need to study the project server ERD carefully to make sure you're catching everything you need.

IF - and that's a capital 'IF' - you were to do this, I'd recommend you write a stored procedure that finds all the right pieces of data and either exports them to a file format that can be imported elsewhere or does inserts directly into the other db instance.

I'm pretty comfortable with SQL stuff but I'm not sure I'd want to dive into this one. Unless I had a week to spend on nothing but this one task.

Earl
Hi,

I want to backup a single project plan and its associated timesheet
entries and then would like to restore them in a different
ProjectServer.

How can I do this in MS-Project Server 2003?

Please help.

regards,

Surajit Laha

 

[ccdetail]

Rather than committing to maintain an MSProject-based timesheet
application for the rest of your life, why not install the free one
from http://journyx.com/newsg?
It's web-based, tracks time, expenses and mileage - automates payroll,
billing and project management, and it's free. It pushes data into
Project and pulls it out too.