[rt-users] Improved RT2 to RT3 scripts

[Jesse Vincent]

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.
> 

Hang on! We actually have an end-user who's pointed us at their
super-fast scripts to do the same. Let me go pull a link.

> 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.
> 
> -- 
> -- Steve Scaffidi <stephen at scaffidi.net>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

--