<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div style="font-family:Tahoma; font-size:13px">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">From what I read, this is what I think I know so far:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">1. They should take the database for 4.2.0 on the MySQL server and use
<a href="https://www.bestpractical.com/docs/rt/4.2/rt-validator.html">RT-Validator</a> to ensure the database is self-consistent.
<o:p></o:p></p>
<p class="MsoNormal">2. Next they should use <a href="https://www.bestpractical.com/docs/rt/4.2/rt-serializer.html">
RT-Serializer</a> 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.
<o:p></o:p></p>
<p class="MsoNormal">3. Finally, they need to use <a href="https://www.bestpractical.com/docs/rt/4.2/rt-importer.html">
RT-Importer</a> to import the cloned, serialized database from the disk onto the Oracle Database with RT4.2 already installed.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Follow-up questions:<o:p></o:p></p>
<p class="MsoNormal">Are the utilities described above easily found and operated? I have never seen the back end of RT.<o:p></o:p></p>
<p class="MsoNormal">How long should the conversion take with a database containing 108,000 tickets?<o:p></o:p></p>
<p class="MsoNormal">Are there any errors or issues that I should keep an eye out for when the DBAs do the conversion?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am sorry if this is a basic question, I am not knowledgeable about database administration and migrations.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am looking for any assistance I can get.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks you for your time.<o:p></o:p></p>
<p class="MsoNormal"><br>
</p>
<p class="MsoNormal">Sincerely,<o:p></o:p></p>
<p class="MsoNormal">Greg<o:p></o:p></p>
</div>
</div>
</body>
</html>