Home

Project owner tool

Physical archive tool

Project Grader Tool

Contact Us

Home > Archive tool

Purpose: Physically Archive Projects from the Project Server database, reducing its size to prevent or ameliorate negative impact on system performance.

Functionality: Project is archived to a second database on the same server as the Project Server database. The archive database will be seeded with basic resource information and enterprise global information. We provide admin functionality in which an Administrator can see all projects available in the production environment using an interface similar to Categories)

Before Archive

After Archive

When the user selects an Active Project and clicks “Archive”, the application runs a series of steps on the backend, first executing a stored procedure in the main Project Server database to copy project information to the Archive Database, then deleting the original.  Selecting an Archived Project and clicking “Restore” performs the steps in reverse, bringing the project back to the Active database. Currently, only one project can be moved at a time.

The user also has the option of synchronizing metadata, including the Enterprise Resource Pool, Security (Groups and Categories), Views, and the Enterprise Global.  The metadata is always copied from the Active database to the Archive and never vice-versa.

Benefits

• Improvement in performance due to database size reduction
• Single projects can be archived.
• Projects can be easily restored back to production.
• Enterprise Global is synchronized if different.
• Enterprise Resource Pool is synchronized.
• Security is synchronized.
• Risk and Issues can be accessed.
• OLAP cube can be built in Archive Environment without publishing projects.
• Projects can be viewed read-only in Archive environment.
• Project Information is available in Project Center Views.
• Project Information is available in Project Views.
• Risk and Issues Links are available in Project Center.
• Risk and Issues Links are available in Project Views.
• Resource Assignments can be viewed.
• Protected and Web Actual data is retained during Archive.
• Enterprise (Project Information) is retained during Archive