Mailing List Archive: Request Tracker: Users

Migrating from RT MySQL to PostgreSQL

Index | Next | Previous | View Threaded

torben.nehmer at cancom

Nov 26, 2009, 8:07 AM

Post #1 of 6 (1160 views)
Permalink

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 [at] cancom<mailto:torben.nehmer [at] cancom>
www.cancom.de<http://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!

elacour at easter-eggs

Nov 26, 2009, 8:22 AM

Post #2 of 6 (1106 views)
Permalink

Re: Migrating from RT MySQL to PostgreSQL [In reply to]

On Thu, Nov 26, 2009 at 05:07:20PM +0100, Nehmer Torben wrote:
> 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://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical

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

ruslan.zakirov at gmail

Nov 26, 2009, 8:27 AM

Post #3 of 6 (1111 views)
Permalink

Re: Migrating from RT MySQL to PostgreSQL [In reply to]

http://wiki.bestpractical.com/view/MySQLToPg

2009/11/26 Nehmer Torben <torben.nehmer [at] cancom>:
> 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 [at] cancom
> 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 [at] bestpractical
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

--
Best regards, Ruslan.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical

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

david.hobley at mionegroup

Dec 5, 2009, 11:43 PM

Post #4 of 6 (989 views)
Permalink

Re: Migrating from RT MySQL to PostgreSQL [In reply to]

----- Original Message -----
From: "Emmanuel Lacour" <elacour [at] easter-eggs>
To: rt-users [at] lists
Sent: Friday, 27 November, 2009 3:22:53 AM
Subject: Re: [rt-users] Migrating from RT MySQL to PostgreSQL

On Thu, Nov 26, 2009 at 05:07:20PM +0100, Nehmer Torben wrote:
> 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

elacour at easter-eggs

Dec 6, 2009, 8:21 AM

Post #5 of 6 (982 views)
Permalink

Re: Migrating from RT MySQL to PostgreSQL [In reply to]

On Sun, Dec 06, 2009 at 05:43:05PM +1000, David Hobley wrote:
>
> 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 ;)

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

Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical

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

elacour at easter-eggs

Dec 6, 2009, 8:24 AM

Post #6 of 6 (992 views)
Permalink

Re: Migrating from RT MySQL to PostgreSQL [In reply to]

On Sun, Dec 06, 2009 at 05:21:52PM +0100, Emmanuel Lacour wrote:
> On Sun, Dec 06, 2009 at 05:43:05PM +1000, David Hobley wrote:
> >
> > 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 ...

Attachments:

mysql2pg.pl (8.50 KB)

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads