[rt-users] Improved RT2 to RT3 scripts

[Dominic Hargreaves]

On Wed, Oct 07, 2009 at 12:01:53PM -0400, Steve Scaffidi wrote:
> What's the interest out there for a several-order-of-magnitudes-faster
> set of export-import scripts a-la RT::Extension::RT2toRT3 ?
> 
> I currently have code capable of exporting the data from an RT
> database with over 181,000 tickets and over 117,000 user accounts in
> under four hours.
> 
> The import script is not yet complete, but I'm shooting for similar
> performance gains. All that's left is the ticket import which is
> proving to be more difficult to get right (with the necessary
> performance) than I initially hoped. If anybody has a *much* faster
> means of importing the tickets themselves, I would love to integrate
> that code!
> 
> The intermediate data format is *exactly* the same as produced by the
> scripts in RT::Extension::RT2toRT3.
> 
> My versions of these scripts only work on postgresql, but they could
> probably be modified to work just as well on mysql with little effort.

I would definitely be interested. I'm currently working on an RT2 to
RT3 upgrade with around 500,000 tickets and without any tuning the
import seems to be taking around a week (I think the export took around
8-12 hours). Our preferred database is PostgreSQL.

This was with the latest devel release of RT::Extension::RT2toRT3.

-- 
Dominic Hargreaves, Systems Development and Support Team
Computing Services, University of Oxford