Upgrade / Port to Oracle

Hi, I wonder if anyone on this list can point me in the right direction for
what I’m about to try:

  1.   Port our RT onto a new piece of hardware
    
  2.   Upgrade our RT to the latest greatest stable version
    
  3.   Port our Mysql version to Oracle
    

Our current environment is:

Red Hat Enterprise Linux ES release 4

RT v3.4.6

Apache 2.0.52

Mysql 4.1.20

perl-5.8.5

Any assistance or reference to documentation would be much appreciated.

Jim Adcock

Director of IT and Billing

Cityfone Telecommunications Inc.

101-3991 Henning Drive

Burnaby BC V5C 6N5

t: 604 629 8848

c: 604 726 7674

f: 604 205 9151

Jim Adcock wrote:

Hi, I wonder if anyone on this list can point me in the right direction
for what I�m about to try:

  1.   Port our RT onto a new piece of hardware
    
  2.   Upgrade our RT to the latest greatest stable version
    
  3.   Port our Mysql version to Oracle
    

Biggest problem is going to be the fact that Oracle isn’t 'binary safe’
and mysql is. You’ll need to convert all binary attachments to base64
and update the database table attachments accordingly.
I don’t know whether for example Oracle SQL Developer can do this. It
has a migration wizard for going from MySQL to Oracle and if you can
combine this with an on insert trigger you might accomplish the
conversion on the fly.

This topic has come up a few times in the last 6 month, also search the
user list.

If you need further help, let me know,

Joop