Project Server IT Professionals Bookmarks

For the upcoming TechEd for IT Professionals in Orlando we have prepared a list of about 70 bookmarks Project Server IT Professionals should be aware of. This list contains bookmarks to valuable resources such as deployment guides, deployment templates, recommended RSS feeds subscriptions, books, training course, etc… Also note the following newly released project templates:…

2

How to Rename Projects After a Project Server 2007 Migration

You have probably noticed after a Project Server 2003 to a Project Server 2007 migration that all the project name have the string “_Published” appended at the end (check Migration guide for Office Project Server 2007). Mike Shughrue has written a tool that will “bulk” rename all the projects in one click as shown below:…

1

Project Server Statistics

Do you ever need to do an audit of your Project Server 2007 data (prior to a migration, to cleanup unnecessary data, to track the historical volume of data…)? Please find attached a T-SQL script that will retrieve the following information: General Project statistics (number of projects, number of resources…) Custom Fields and Lookup Tables…


Sample COM Add-in code for Project Professional 2007

Please find below sample code (thank you Mike Shughrue) in C# for a Project Professional 2007 COM Add-in.  This code is very similar to writing a COM Add-In Project Professional 2003. In the long term an easier way to start would be to leverage new next version of Visual Studio Tools For Office (VSTO): http://blogs.msdn.com/project_programmability/archive/2007/07/30/vsto-add-in-support-for-project-2003-and-project-2007.aspx…


Impact of Latency on Project Professional 2007

Please find below a study I did for a customer to demonstrate the advantage of the new EPM 2007 architecture and specifically how Project Professional 2007 communicates to the application server. DISCLAIMER: the times presented below highly depend on the EPM Architecture, the project plan data, as the network between the test machine and the…

1

Newly published content for Office Project Server 2007: Week of May 14, 2007

For your information the following content has been published on TechNet, specifically of interest how to backup and restore a PWA instance from one server to another (from a development environment to a production environment for instance): Administering backup and recovery for Project Server 2007 Back up item-level objects by using Project Web Access Back…

1

How to update Analysis Views (OLAP) after an EPM 2003 to EPM 2007 migration?

After migrating your database from Project Server 2003 to Project Server 2007, or after migrating from one environment to another (Production to Development for instance), a quick and easy way to update the Data Analysis Views is to issue the following T-SQL command in the REPORTING database:   USE ProjectServer_Published GO   — Check Analysis…


How to install Project Server 2003 & Project Server 2007 on the same server

Thanks to Emmanuel, please find below the sequence to install a mixed Project Server 2003 & Project Server 2007 environment on the same server typically used for testing/merging data during a migration process. ·              Install Winproj (Project Professional) 2003 first, and then install Winproj 2007. They work side by side and thus can coexist on…

2

Sample Project Server 2003 to Project Server 2007 Migration Plan

Due to popular requests, please find below a sample plan to migrate from EPM 2003 to EPM 2007.  Use this plan as a guide and a reminder of all phases and tasks that need to be accomplished during the migration project.  The effort (“work”) for each task does not necessarily represent what is required for…