[rt-users] Migrating from MySql to Oracle

[Hummer, Greg]

Hi,

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.

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?

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.

>From what I read, this is what I think I know so far:

1. They should take the database for 4.2.0 on the MySQL server and use RT-Validator<https://www.bestpractical.com/docs/rt/4.2/rt-validator.html> to ensure the database is self-consistent.
2. Next they should use RT-Serializer<https://www.bestpractical.com/docs/rt/4.2/rt-serializer.html> 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.
3. Finally, they need to use RT-Importer<https://www.bestpractical.com/docs/rt/4.2/rt-importer.html> to import the cloned, serialized database from the disk onto the Oracle Database with RT4.2 already installed.

Follow-up questions:
Are the utilities described above easily found and operated? I have never seen the back end of RT.
How long should the conversion take with a database containing 108,000 tickets?
Are there any errors or issues that I should keep an eye out for when the DBAs do the conversion?

I am sorry if this is a basic question, I am not knowledgeable about database administration and migrations.

I am looking for any assistance I can get.

Thanks you for your time.

Sincerely,
Greg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150121/c9e568b2/attachment.htm>