[rt-users] RT2 database cleanup before rt2->rt3 migration

[Ruslan U. Zakirov]

brianBOFH wrote:
> RT guru's:
> 
> I would like to clean up my RT2 instance in perparation for migration
> to RT3.  What is the best way to accomplish this?  My biggest concern
> is the Users table.  We have an enormous amount of "SPAM" users and
> only about 120 privileged users.  There is also a large amount of dead
> Tickets.  Any suggestions are appreciated.
sponsor BestPractical to help you migrate

hire third party to acomplish one of the next tasks or do it yourself:

hack on rt2-to-rt3 tool to skip dead tickets while export. Easy I think, 
but it's not easy to skip users(and all around it!) that has no 
relations with live objects. I say object cause ticket is not only one 
DB record but many records. also user can be owner or cc for some live 
ticket, but have no tickets requested at all, so you should check all 
relations to be sure that your DB is consistent.

as far as I know there is purge-dead.pl script for RT2 that remove 
tickets. Nobody right now can guaranty that after using it you'll 
happily migrate, so you have to back up DB before using it, then after 
migrate you should test RT3 as much as possible.

If you know how to hack on RT2 API then you can recheck code in 
purge-dead.pl

You can migrate to RT3 first and then use RTx::Shredder.
	But it doesn't clean up Users table well yet.
	But you should put all that dead tickets into RT3 DB first.

> 
> Thanks,
> Brian

[snip]
Hmm, huge DB.


					Best regards. Ruslan.