[rt-users] Data migration from 2.0.x to 3.4.x

[Drew Barnes]

Quoting Jim Archer <jim at archer.net>:

> Hi Al...
>
> I'm running RT 2.0.13 and should have upgraded to 3.4.x ages ago, but I am
> finally looking in to how to do that now.  I'm running it on Debian Woody
> but the upgrade will go to Sarge or possible even unstable, on a new PC.
> The database will be PostgreSQL.
>
> I see that there is a nice Debian package available for both testing and
> unstable, which I am guessing will be upgraded to the May 4th release
> soon.  Installing the new RT 3.4.x seems easy enough.
>
> What I am wondering, though, is if it is possible to migrate the existing
> data from my RT 2.0.x the new RT 3.4.x installation.

Look for the rt2-to-rt3 package in the Contributions section under downloads. 
Make sure to dump the data BEFORE you install the updated version of RT and fix
the dependancies.

> I searched around
> the Best Proactical site but didn't find any information about how to do
> this.  Ideally, I would want to do this after the installation is complete
> and the new RT is configured.

If this is how you want to do it, you will need to get a second box set up and
begin by installing 3.2.2 or 3.2.3 on it.  AFAIK, the dumpfile-to-rt3 script
won't import cleanly into rt 3.4.x.  Import your data, unpack RT 3.4.x, fix
dependencies, and make upgrade.  Be sure to run the schema/acl/content changes
after the upgrade.

DB