[rt-users] Migration to a new server

[ktm at rice.edu]

On Fri, Apr 05, 2013 at 05:16:44PM +0100, Gary Mason wrote:
> Hi,
> 
> I have inherited an RT 3.6.7 system with around 300,000 tickets in
> it, taking up about 40GB of disk space.
> 
> The hardware this runs on is getting on a bit, and response times
> are now getting to the frustratingly slow point.
> 
> I have a new server (Debian Squeeze) on which I have managed to get
> RT 4.0.7 up and running via backports PPA.  I have managed to
> include all the configuration and scrips from the existing system,
> and have created a few tickets in order to be able to demonstrate
> the updated UI/reporting/graphs etc to the helpdesk team.  People
> here are impressed :)
> 
> My problem is that I have been asked to migrate all the current
> tickets over to the new system in order to retain history.  I have
> next to no postgresql knowledge and am at a loss as to how to do
> this. I have briefly looked at the migration documents online, but I
> can't find anything that resembles a "run this script, point it to
> the current and new installations, cross your fingers and hold your
> breathe ..." type of migration script that would be so useful.
> 
> Is there anything that I can read, or can anyone offer some
> suggestions, as to how I can get the ticket information from the
> current to the new server ?
> 
> Thanks,
> Gary
> 

Hi Gary,

There are README and UPGRADING documents that come in the source
distribution from Best Practical. You will need to follow those
documents to upgrade the current database.

Regards,
Ken