Forum Sponsor:

Oracle Construction and Engineering (formerly Primavera) is transforming the world by helping organizations plan, build, and operate critical assets with on-premise and cloud-based project portfolio management solutions.  Learn more about Oracle Construction and Engineering...

We wish a warm welcome to the find people who are offering the PrimaveraReader application. We hope to add more interesting news here shortly.

Primavera Reader Free Trial

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 9 weeks 4 days 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 day 23 hours ago. Offline
Joined: 13 Jul 2009
Posts: 1981

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 2 weeks 51 min ago. Offline
Joined: 19 Oct 2004
Posts: 546

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