Migrating from Pg to mysql

Hi everyone,

I’m about to try Jesse’s rt3-on-pg-to-mysql script, but I’ve got a couple
quick questions:

  1. Does it depend on a specific version of RT?

  2. Assuming that all the relevant perl modules are installed and the script
    runs successfully, do I need to do anything beyond modify the
    RT_SiteConfig.pm file to use:

Set($DatabaseType , ‘mysql’);

BTW, I’m using the Debian RT package for RT 3.2

Thanks,
Tim

Timothy Wilson
Technology Integration Specialist
Hopkins ISD #270, Hopkins, MN, USA (44š56.013’N 93š24.736’W)
ph: 952.988.4103 fax: 952.988.4311 AIM: tis270

I’m about to try Jesse’s rt3-on-pg-to-mysql script, but I’ve got a couple
quick questions:

I’m sure you have a good reason for abandoning a real database for
(oh, let’s pick something out of this week’s list traffic) something
without a query optimizer (:-)…

but I’d really like to know what it is, if you don’t mind sharing. :slight_smile:

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me