Postgres to Mysql tool?

RT Users
1

Is there such a beast? Looked in the archives We have RT 2 on postgres
and want to go to RT3 on Mysql 4.

	Best,

		Tom
2

At Sat, 28 Jun 2003 12:59:43 -0500,
Tom ONeil wrote:

Is there such a beast? Looked in the archives We have RT 2 on postgres
and want to go to RT3 on Mysql 4.

You can use the standard RT2->RT3 conversion tools. Just configure
your RT3 instance to use Mysql. The “intermediate” format should be
database independent.

-R

3

You can use the standard RT2->RT3 conversion tools. Just configure
your RT3 instance to use Mysql. The “intermediate” format should be
database independent.

It should but isn’t fully.

For mysql->postgres migration you have to modify attachments that
contain NUL-characters, because the postgres API doesn’t support
constants containing NUL-characters.

For postgres->mysql this is not a problem, you just waste some
space because the attachments will be stored base64-encoded when
not necessary.

Greetings,
,eM"“=. a”-. Michael van Elst
dWWMWM" - :GM==; mlelstv@dev.de.cw.net
:WWMWMw=–. "W=’ cable & wireless
9WWMm==-.
“-Wmw-” CABLE & WIRELESS