Copying OTRS Data between version 5 and 6 on different servers

[retro2707]

Hi,

We have an old version 5 machine with OTRS and the KIX addon installed. We wanted to migrate to a new server and put on version 6 (Kix is not supported on that version) but retain the ticket, sla and agent data.

I found a module called DB clone, which only seems to work on a blank db? I really want to import the data into the existing version 6 DB.

Anyway, even creating a new DB on the new version 6 server and trying to export the data there I got the error below.

Any ideas on the points above or the error please?

Thanks!

Code: Select all

ERROR: OTRS-otrs.Console.pl-Maint::Database::Clone-01 Perl: 5.10.1 OS: linux Time: Thu Oct 11 15:08:42 2018

 Message: Table 'otrs-clone.change_freekey' doesn't exist, SQL: '
            SELECT COUNT(*)
            FROM change_freekey'

 Traceback (15802):
   Module: Kernel::System::CloneDB::Driver::Base::RowCount Line: 171
   Module: Kernel::System::CloneDB::Driver::Base::SanityChecks Line: 125
   Module: Kernel::System::CloneDB::Backend::SanityChecks Line: 269
   Module: Kernel::System::Console::Command::Maint::Database::Clone::Run Line: 100
   Module: (eval) Line: 460
   Module: Kernel::System::Console::BaseCommand::Execute Line: 454
   Module: Kernel::System::Console::InterfaceConsole::Run Line: 86
   Module: bin/otrs.Console.pl Line: 38

Error: Died at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 171.

[root]

Hi,

I would try to use the databasedump from OTRS 5 for OTRS 6 and the configuration files (Config.pm, ZZZAuto.pm, TicketCounter.log, etc.) and start a migration form this point. As an alternative you should really consider professional help on this.

- Roy

[retro2707]

Thanks Roy,

Will have a look into this.

Brendan