Moving single queue from one OTRS server to another

Moderator: crythias

Post Reply
qqsrnec
OTRS newbie
Posts: 8
Joined: 24 Jul 2018, 14:02
OTRS Version?: 5.0.23

Moving single queue from one OTRS server to another

Post by qqsrnec » 01 Oct 2018, 14:33

Hello,
I would like to ask you, if it is possible to move single queue (not the whole database, just one queue) from OTRS server to another OTRS server (already working, with different queues).

Thanks
Tom

User avatar
christianclavet
OTRS expert
Posts: 75
Joined: 27 Aug 2018, 13:50
OTRS Version?: Community
Real Name: Christian Clavet
Company: Tact Group

Re: Moving single queue from one OTRS server to another

Post by christianclavet » 01 Oct 2018, 16:07

Hi,

What you would need is a way to export a queue content and re-import it the other system. But I don't see any way to do it directly like that.

Only possible methods I know is (without programming a plugin to export/import queues contents):
- Do a SQL Dump and "filter" manually the queue content. This is tedious and might damage the other database.

- Use of SQL queries to export the content.

Other problems you might have is the tickets attachments, I don't think they are in the DB but stored somewhere in the server.
I'm sorry but I don't think I have any helpful solution at the moment for this problem...
----------------------------------------------
OTRS Community 6.0.11
Debian 9.0

MariaDB

root
Moderator
Posts: 1317
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: Moving single queue from one OTRS server to another

Post by root » 01 Oct 2018, 16:46

Hi,

This won't work without development because you have to adjust all referenced foreign keys for states, users, etc.

- Roy
OTRS 4/5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

You need professional services? Check out https://www.znuny.com/

qqsrnec
OTRS newbie
Posts: 8
Joined: 24 Jul 2018, 14:02
OTRS Version?: 5.0.23

Re: Moving single queue from one OTRS server to another

Post by qqsrnec » 02 Oct 2018, 07:57

Hi,
I thought it would not be easy.... I will keep queues as they are. Thanks for reply.

Tom

wurzel
OTRS guru
Posts: 2536
Joined: 08 Jul 2010, 22:25
OTRS Version?: 6.0.x

Re: Moving single queue from one OTRS server to another

Post by wurzel » 03 Oct 2018, 14:55

Hi,

you can use webservices. But this needs development or commercial addons.

Florian
    ((OTRS)) Community Edition 6.0.x, LAMP LIVE auf Debian 9
    OTRS 6 Managed Silver

    -- Ich beantworte keine Forums-Fragen PN - No PN please

    I won't answer to unfriendly users any more. A greeting and regards are just polite.

    Post Reply