Moving single queue from one OTRS server to another

Moderator: crythias

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

Moving single queue from one OTRS server to another

Post by qqsrnec »

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
christianclavet
Znuny newbie
Posts: 75
Joined: 27 Aug 2018, 13:50
Znuny Version: Community
Real Name: Christian Clavet
Company: Tact Group

Re: Moving single queue from one OTRS server to another

Post by christianclavet »

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
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Moving single queue from one OTRS server to another

Post by root »

Hi,

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

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

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

Do you want to contribute or want to know where it goes ?
qqsrnec
Znuny newbie
Posts: 8
Joined: 24 Jul 2018, 14:02
Znuny Version: 5.0.23

Re: Moving single queue from one OTRS server to another

Post by qqsrnec »

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

Tom
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Moving single queue from one OTRS server to another

Post by wurzel »

Hi,

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

Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- 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