Purging Data from Dragnet DB

This forum is now locked, since gold support is no longer offered.

Moderator: SourceGear

Locked
rcwalden
Posts: 22
Joined: Thu Jan 13, 2005 8:38 am

Purging Data from Dragnet DB

Post by rcwalden » Thu May 19, 2005 8:03 am

How can I purge all of the issues I have added to Dragnet and reset the Issue ID back to 1? We have been testing and want to clear it all out before we begin to enter 'live' issues.

jclausius
Posts: 3617
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Thu May 19, 2005 8:29 am

The easiest way to accomplish this is to re-install the Vault server, and choose to DROP the database upon installation, and start afresh.

Would that work in your situation?
Jeff Clausius
SourceGear

rcwalden
Posts: 22
Joined: Thu Jan 13, 2005 8:38 am

Post by rcwalden » Thu May 19, 2005 8:35 am

It wouldn't, as I don't want to add the 20+ users back into Dragnet and setup the types, statuses, etc. Is there a way to just run SQL Scripts against the tables there to just delete the issues and reset the issue counter back to 1? I can probably manually delete the issues through the web interface but I am getting pressured to reset the numbering back to 1.

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Thu May 19, 2005 10:38 am

We may be able to provide a script for you, but need to test it out first. Stay tuned.
Linda Bauer
SourceGear
Technical Support Manager

rcwalden
Posts: 22
Joined: Thu Jan 13, 2005 8:38 am

Post by rcwalden » Thu May 19, 2005 1:57 pm

Okay, Thanks!!

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Thu May 19, 2005 2:14 pm

Email linda at sourcegear.com and I'll send you something to try.
Linda Bauer
SourceGear
Technical Support Manager

Locked