Database Cleanup - SQLlite - R8.4

there are several thing that you can do

1. Clean the POBS tables in the existing database here is how

Click on start All Programs, Microsoft SQl Server 2005, SLQ Server Management Studio

Authentication: Should be SQL Server Authentication

Login: sa

Password: Prima123Vera

Then click connect

Expand the database folder and click on pmdb$primavera

Then up top select new query

Then type this

delete POBS;

the right click and select execute

now you can close and exit out of sql

2. download this POBS cleaner adn clean every XER file prior to imporing it

http://scheduleanalyzer.com/PurgePOBS.exe

3. You can exort the old projects as xer files save them to a thumb drive, an external hard drive or a network drive then delete these old projects.

4. You can create another database and stsrt to add NEW projects to that database 

SQLite Management Studio. Don't leave home without it.