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 > [email protected] > 831-459-5354 > Baskin Engineering, Room 313A
Hi Tim, That is how I have done it to avoid the notification flurry. Regards, Ken --------- RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017
