Cleanup Project Workspace sites with no documents before Upgrading to 2010

Proposed Cleanup Project Workspace sites with no documents before Upgrading to 2010

  • Friday, 27 April 2012 6:27 PM
     
     

    Hi,

    We are in the process of migrating from EPM 2003 to EPM 2010. While migration we noticed that migration of project workspace sites from 2003 to 2007 and then to 2010 is taking long time even when the project sites have no documents uploaded to it. We want to find all such blank project workspace sites, delete them and then start migrating the project workspace site. However we are very unsure how we can get the data for the same. We are thinking of running a T-SQL on WSS DB to get these details then write a VBA or PSI to automate deletion of these workspace automatically. If any one has ideas regarding how to get the details of project workspace site with no documents uploaded to them request you to please share it.

All Replies