<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=187583016-16052007><FONT face=vt100 size=2>Hey
everyone!</FONT></SPAN></DIV>
<DIV><SPAN class=187583016-16052007><FONT face=vt100 size=2>I'm being forced to
migrate RT 3.6.3 from MySQL 5.0.41 Community Server to Oracle
10g.</FONT></SPAN></DIV>
<DIV><SPAN class=187583016-16052007><FONT face=vt100 size=2>You know, infinite
levels of corporate paranoya and such...</FONT></SPAN></DIV>
<DIV><SPAN class=187583016-16052007><FONT face=vt100 size=2>But in any event,
i've searched the Wiki and found very little on the subject. I did download and
installed the Oracle Migration Workbench tool and successfully connected to my
MySQL instance.</FONT></SPAN></DIV>
<DIV><SPAN class=187583016-16052007><FONT face=vt100 size=2>Am i better off
creating the DB from scratch as part of RT install (i'll also be migrating RT
itself to another box) or is it better to perform an actual migration of the
whole MySQL DB, including the data, to Oracle via the migration
tool?</FONT></SPAN></DIV>
<DIV><SPAN class=187583016-16052007><FONT face=vt100 size=2>Has anyone done this
type of a migration in the past?</FONT></SPAN></DIV>
<DIV><SPAN class=187583016-16052007><FONT face=vt100
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=187583016-16052007><FONT face=vt100 size=2>Also, i'm concerned
about installing extensions such as RTFM and AT with Oracle. I know the schemas
exist but is the installation process different? Do i need to manually load the
schemas first? The Oracle DB will be sitting on another box than RT. Does this
matter?</FONT></SPAN></DIV></BODY></HTML>