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 
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!
The rt-users Archives
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
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 
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
attached to this message …
mysql2pg.pl (8.5 KB)