Since our Production instance is getting big, we would like to move old tickets to an Archive instance and implement a retention policy on Production.
Starting it should fairly be easy but, having to move tickets from Production to Archive on a weekly/monthly basis poses a challenge.
Goal here is to keep everything: comments, attachments, etc.
Initially, a restored on the Archived using the back-up of Production then doing some spring cleaning on both instances would be manageable.
But, how do we go forward when we need to move (or bulk move) selected tickets from Production to Archive? Thereby keeping Production with a low number of tickets and just dumping old tickets on Archive every week/month.
Maybe someone has done this before. 