[rt-users] RTx-Shredder question

[Frank Pater]

>    On 7/13/06, Frank Pater <[1]fpater at dca.net> wrote:
> 
>      Hello,
> 
>      On Thu, Jul 13, 2006 at 11:48:46AM -0400, [2]spydrrrrr at gmail.com wrote:
> 
>      <snip>
>      Will that leave too many other linked tables with data that is not
>      linked? Is that why we should use RTx-Shredder?
>      <snip>
> 
>      Simply put, yes :)
> 
>    However is this a bad thing? I mean if there is data in the database that
>    I do not want and is associated with an ID number that does not exitst
>    does that matter?
> 

Yes, it can break the WebUI. For example, attempting to load a ticket that contains a link to another ticket that has been removed from the database causes the web interface to dump an error which prevents you from accessing the existing ticket. Ruslan would have to confirm this, but I believe that Shredder will remove the link in the existing ticket when the referenced one is deleted from the database. 

Based on my experience restoring stuff from Shredder's sql dumps, I can confidently say that when it removes a single ticket from the database, many SQL actions occur. From this, I gather there is much more complexity involved than the situation I describe above.

Sincerely,
Frank Pater
DCANet
http://www.dca.net
voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060713/5925da35/attachment.sig>