Hi, I work at a support desk currently using RT 4.0.6 on a MySQL server and we need to switch to RT 4.2.0 on a Oracle Server for fulltext search among other thing. The database administrators are not very familiar with RT, but they have successfully upgraded 4.0.6 MySQL to 4.2.0 MySQL on a test server.
My question, is there any step by step document, guidance, or video that I can provide to the DBA’s to assist them in the conversion to Oracle? I was told that RT 4.2 includes utilities such as the RT-Validator, RT-Serializer, and RT-Impoter to assist in this process. I have read though the documentation provided on the BestPractical website, but still cannot verify what directions to give to the DBAs. >From what I read, this is what I think I know so far: 1. They should take the database for 4.2.0 on the MySQL server and use RT-Validator<https://www.bestpractical.com/docs/rt/4.2/rt-validator.html> to ensure the database is self-consistent. 2. Next they should use RT-Serializer<https://www.bestpractical.com/docs/rt/4.2/rt-serializer.html> to write out the RT database to a disk. During the process of using RT-Serializer, the tech team needs to enable the Clone feature. 3. Finally, they need to use RT-Importer<https://www.bestpractical.com/docs/rt/4.2/rt-importer.html> to import the cloned, serialized database from the disk onto the Oracle Database with RT4.2 already installed. Follow-up questions: Are the utilities described above easily found and operated? I have never seen the back end of RT. How long should the conversion take with a database containing 108,000 tickets? Are there any errors or issues that I should keep an eye out for when the DBAs do the conversion? I am sorry if this is a basic question, I am not knowledgeable about database administration and migrations. I am looking for any assistance I can get. Thanks you for your time. Sincerely, Greg
