MySql to Oracle migration

RT Users
1

I’m looking to migrate our RT v3.8.8 from MySql to Oracle. Has anyone done this before and if so any recommended steps? Any direction would be helpful!

Thanks,

Jeff

2

I am unsure where to look to change the connect string from my current database to the new oracle database. Any suggestions?

-JeffFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Lee, Jeffrey
Sent: Monday, October 04, 2010 4:53 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] MySql to Oracle migration

I’m looking to migrate our RT v3.8.8 from MySql to Oracle. Has anyone done this before and if so any recommended steps? Any direction would be helpful!

Thanks,

Jeff

3

Lee, Jeffrey wrote:

I am unsure where to look to change the connect string from my current
database to the new oracle database. Any suggestions?

I haven’t migrated from Mysql to Oracle but do use Oracle.
If you haven’t done so already, run configure with the appropriate
settings for Oracle, this is mine:
./configure --with-db-type=Oracle --with-db-dba=system --enable-gd
–enable-graphviz --enable-devel-mode --with-web-handler=modperl2
–with-db-database=$ORACLE_SID
where $ORACLE_SID is the instance name, sid, of the Oracle database
you’re connecting to, or the tnsnames alias if its a remote db.
Further you’ll need to change RT_SiteConfig.pm to use Oracle instead of
Mysql.

Set($DatabaseName , ‘$ORACLE_SID’);
Set($DatabaseType , ‘Oracle’);

This should get going. Please beware that you read the DBD::Oracle
README before installing it. If you’re environment is not set correctly
make test will fail and it won’t install.
Also watch the version of DBD::Oracle. Search the archives for more info.

Regards,

Joop