migrate otrs from PROD to DEV

[rvaldomir]

Hi,

-OTRS web application on debian
-OTRS database Oracle 11g

does anyone knows how to move/propagate changes and migrate all the configurations from one environment to another?

Now I need to create a DEV environment with actual PROD configuration.

How to???

[wurzel]

Hi,

read doc.otrs.org backup/restore or upgrade section.
There is no built-in function for transferring configuration devel -> test -> int -> prod environments.

Flo

[rvaldomir]

Hi,

I already checked it but this will work only with Postrgress and MySQL, and I have Oracle.

I have disabled the DB backup and was able to extract the info, after that I recover a full database backup into a new schema in my DEV DB. My plan is to install OTRS from the scratch using this DB could be possible?

Other chance is to re-point my OTRS DEV to the new schema and run the restore.pl to restore the files.

What do you think?

[wurzel]

Hi,

replace MySQL/Postgres/Oracle with $DATABASE it is always the same. Database is database.

then:
set up a new DEV machine (linux)
Install $DATBASE driver in your dev machine (for oracle Full Oracle Client)
set up a perl DBD connector for $DATABASE on dev machine (in your case DBD::Oracle)
dump $DATABASE from production
restore $DATABASE in dev
backup and restore OTRS configuration files (mentioned in doc.otrs.org) and reconfigure for dev host+database

if backup.pl/restore.pl is not working for oracle then use SQL dump and SQL restore with Oracle tools.

and yes, installing OTRS from scratch and/or pointing to new/old schema is possible.

read the READMES (install and database) files in /opt/otrs/

Cheers
Flo

[menkman]

Hi,

what do you thing about virtualize the System?
If the Program and the Database located on the same physical System I think that's the best Practice.

Best
Claus