Has anyone migrated from PSQL to MYSQL?

RT Users
1

Takers?

2

Takers?

Not yet, but I am planning this on an installation with several thousand
RT 2.x tickets, moving ot RT 3.4.4. I will be following this thread with
great interest.

Scott

Scott Courtney | “I don’t mind Microsoft making money. I mind them
scott@4th.com | having a bad operating system.” – Linus Torvalds
http://4th.com/ | (“The Rebel Code,” NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey

3

I notice there is a psql to mysql perl script but it looks highly
rudimentary, I am very curious if anyone has done such a migration,From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Scott
Courtney
Sent: Tuesday, November 22, 2005 10:15 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Has anyone migrated from PSQL to MYSQL?

Takers?

Not yet, but I am planning this on an installation with several thousand
RT 2.x tickets, moving ot RT 3.4.4. I will be following this thread with
great interest.

Scott

Scott Courtney | “I don’t mind Microsoft making money. I mind
them
scott@4th.com | having a bad operating system.” – Linus
Torvalds
http://4th.com/ | (“The Rebel Code,” NY Times, 21 February 1999)
| PGP Public Key at
http://4th.com/keys/scott.pubkey
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html

4

Piszcz, Justin napisaďż˝(a), Dnia 2005-11-22 17:47:

I notice there is a psql to mysql perl script but it looks highly
rudimentary, I am very curious if anyone has done such a migration,

I have gone through it and it went pretty smoothly with 3.0.x.
but it was a simple installation with no links between tickets, no fancy
actions, etc. (50 000 tickets though…). keep in mind that you will
have to recreate many things in your setup (AFAIR) after dumping and
reimporting the data.

regards,
Alek Cesarz
Operations Director

Crowley Data Poland Sp. z o.o.
tel. +48(22)8606960
fax. +48(22)8606796
ul. Stawki 2, 00-193 Warszawa