Has your question already been answered?

Get a quicker response; before you post, why not search to see if it has already been answered

Database Cleanup - SQLlite - R8.4

2 replies [Last post]
Andrew Sargent
User offline. Last seen 6 days 16 hours ago. Offline
Joined: 29 Jan 2015
Posts: 2
Groups: None

After reaching the 4GB limit on the XE database for the 1000th time I decided to just switch over to SQLlite. I have no reached the point where even my SQLlite database is bloated with POBS and old codes. Can someone tell me how to cleanup my sqllite DB? 

Replies

Zoltan Palffy
User offline. Last seen 1 hour 40 min ago. Offline
Joined: 13 Jul 2009
Posts: 1915

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 

 

David Kelly
User offline. Last seen 7 weeks 2 days ago. Offline
Joined: 19 Oct 2004
Posts: 536

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