Conectare
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Delete all the projects from database

Answered Delete all the projects from database

  • 5 aprilie 2012 19:29
     
     
    Sign in pentru a vota
    0

    hi,

    I am using Project Server 2007 (SP3) with SQL Server 2005.

    I have ~35,000 projects in the database and I want to delete all the projects. On average it is taking 10 minutes to delete one projects from Database Administration-> Delete Enterprise Objects.

    Is there any quicker way to delete these projects?

    Thanks!

     

Toate mesajele

  • 5 aprilie 2012 21:44
     
     Răspuns
    Sign in pentru a vota
    1

    What is the data that you care about? You could use the Playbooks tool to backup all configuration (custom fields etc.), create a new PWA instance and import those values, and delete the current PWA instance.

    Alternatively, you could use the PSI to programatically delete projects.

    www.umt.com | www.umtprojectessentials.com

     
  • 9 aprilie 2012 19:50
     
     Răspuns
    Sign in pentru a vota
    0

    There's a project called ProjTool comes with the Project Server SDK. I'm not sure it would work with 2007 but you can give it a try. It give you GUI based access to your database which can quickly add, modify and delete projects in one go.

    Thanks, Kashif