Hi Luick,
Greetings...
Suddenly... out of the blue... I become the nominated "special one" to migrate my company's otrs.
I have otrs 2.0.1 up and running... and I intent to migrate to otrs 2.2.5 with oracle 11g DB (since it's a policy agreement for company's DB). Since I'm new to otrs... I'm asking for some guidelines about it...
Should I firstly migrate otrs 2.0.1 to 2.2.5 (following this http://lists.otrs.org/pipermail/otrs/2008-February/022074.html )... and then migrate mysql to oracle? Does anyone ever tried (successfully) to migrate mysql to oracle? Should I just do a mysql dump.... use some application to import the dump to oracle... and then run the otrs script (DBUpdate-to-2.2.oracle.sql) for oracle?
I would upgrade, then dump, then migrate. Here are some helpful tipps for things to backup before migrating: (don't mind that they are other platforms) http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&Subaction=Search&Submit=... Just look at the steps generically. :) But, having said that, the jump your company wants to make brings so many features with it, I must tell you: It would be advisable to get consulting help from us. It would save you time, and your ROI for this investment would be much better because you would not have to spend a long time fiddeling with things to understand them and getting things to work. Please request an offer from enjoy@otrs.com. Otherwise, there are many people here that are more than happy to help you. I wish you luck either way you decide. ((enjoy)) -- Shawn Beasley ((otrs)) :: OTRS AG :: Norsk-Data-Straße 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftssitz: Bad Homburg Amtsgericht Bad Homburg, HRB 10751 Steuernummer: 003/240/97521 Aufsichtsratsvorsitzender: Burchard Steinbild Vorstandsvorsitzender: André Mindermann