로그인
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Delete all the projects from database

Respondida Delete all the projects from database

  • 2012년 4월 5일 목요일 오후 7:29
     
     
    로그인하여 투표
    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!

     

모든 응답

  • 2012년 4월 5일 목요일 오후 9:44
     
     답변됨
    로그인하여 투표
    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

     
  • 2012년 4월 9일 월요일 오후 7:50
     
     답변됨
    로그인하여 투표
    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