[rt-users] Postgres to Mysql tool?

Michael van Elst mlelstv at dev.de.cw.net
Sun Jun 29 05:37:30 EDT 2003


On Sat, Jun 28, 2003, Robert Spier wrote:

> 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 at dev.de.cw.net
  :WWMWMw=--.          "W='  cable & wireless
   9WWMm==-.
    "-Wmw-"  CABLE & WIRELESS



More information about the rt-users mailing list