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

[Drew Barnes]

Quoting Tim Suter <tsuter at cait.org>:

> Hi Drew,
>
> Would this be the same mentality with MySQL as the db engine?
>
> Tim

Yes, this is db-independant.  The rt2-to-rt3 package was written for 3.1.17 (I
think)/3.2.x and there were some pretty major schema changes for 3.4.x.  There
should be instructions for upgrading the schema after you do make upgrade on a
3.2.x installation.

Also, please make sure to CC the list so that others can give input and so that
the answers are put in the list archives.

Hope this gets you going.

DB


> On Mon, 2005-05-23 at 14:22 -0400, Drew Barnes wrote:
> > 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
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
>