Migrating from RT MySQL to PostgreSQL

Hello together,

has anybody ever migrated RT from MySQL to PostgreSQL? Are there any scripts available to accomplish this?

Greetings,
Torben Nehmer
Torben Nehmer
Diplom Informatiker (FH)
Business System Developer
CANCOM Deutschland GmbH
Messerschmittstr. 20
89343 Scheppach
Germany
Tel.: +49 8225 - 996-1118
Fax: +49 8225 - 996-41118
torben.nehmer@cancom.demailto:torben.nehmer@cancom.de
www.cancom.dehttp://www.cancom.de
CANCOM Deutschland GmbH
Sitz der Gesellschaft: Jettingen-Scheppach
HRB 10653 Memmingen
Geschäftsführer: Paul Holdschik, Christian Linder
Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt!
This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee!

Hello together,

has anybody ever migrated RT from MySQL to PostgreSQL? Are there any scripts available to accomplish this?

you can start here: http://wiki.bestpractical.com/view/MySQLToPg :slight_smile:

I did it with a slighty modified script to handle some encoding problems
we had with our MySQL DB.

http://wiki.bestpractical.com/view/MySQLToPg2009/11/26 Nehmer Torben torben.nehmer@cancom.de:

Hello together,

has anybody ever migrated RT from MySQL to PostgreSQL? Are there any scripts
available to accomplish this?

Greetings,
Torben Nehmer


Torben Nehmer
Diplom Informatiker (FH)
Business System Developer

CANCOM Deutschland GmbH
Messerschmittstr. 20
89343 Scheppach
Germany

Tel.: +49 8225 - 996-1118
Fax: +49 8225 - 996-41118
torben.nehmer@cancom.de
www.cancom.de

CANCOM Deutschland GmbH
Sitz der Gesellschaft: Jettingen-Scheppach
HRB 10653 Memmingen
Geschäftsführer: Paul Holdschik, Christian Linder

Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und
ausschließlich für den Gebrauch durch den Empfänger bestimmt!
This e-mail and any files transmitted with it are confidential intended
solely for the use of the addressee!


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Hello together,

has anybody ever migrated RT from MySQL to PostgreSQL? Are there any scripts available to accomplish this?

you can start here: http://wiki.bestpractical.com/view/MySQLToPg :slight_smile:

I did it with a slightly modified script to handle some encoding problems
we had with our MySQL DB.
----- Original Message End -----

We have been trying to do this using this page, but we have never managed to get the binary attachments across successfully. If you have any luck with this, we are definitely interested in hearing about it.

Cheers,
David

We have been trying to do this using this page, but we have never
managed to get the binary attachments across successfully. If you have
any luck with this, we are definitely interested in hearing about it.

attached the version I used to migrate our DB without any loss … test
it :wink:

We have been trying to do this using this page, but we have never
managed to get the binary attachments across successfully. If you have
any luck with this, we are definitely interested in hearing about it.

attached the version I used to migrate our DB without any loss … test
it :wink:

attached to this message …

mysql2pg.pl (8.5 KB)