Hi, I wonder if anyone on this list can point me in the right direction
for what I�m about to try:
Port our RT onto a new piece of hardware
Upgrade our RT to the latest greatest stable version
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.