[rt-users] Moving Tickets in Bulk

[Kenneth Marshall]

On Mon, Sep 12, 2016 at 09:08:44AM -0700, Tim Gustafson wrote:
> We just finished importing around 50,000 tickets from one RT instance
> into another instance with its own large collection of tickets.  The
> rt-importer script put them into new queues (which we expected) rather
> than the ones we had already created in the destination system for the
> cut-over.  I went in to start moving tickets from the imported queues
> into the correct ones, and noticed that it's kinda slow, and it's
> sending notification e-mails (via scrips) for each move.
> 
> What's the safest way to move tickets from one queue to another in
> bulk without sending notification e-mails?  Is it safe to just do:
> 
> update Tickets set queue = 1234 where queue = 4321
> 
> in Postgres?  I don't care so much if the ticket's transaction history
> doesn't show the move.
> 
> -- 
> 
> Tim Gustafson
> tjg at ucsc.edu
> 831-459-5354
> Baskin Engineering, Room 313A

Hi Tim,

That is how I have done it to avoid the notification flurry.

Regards,
Ken