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
Moving single queue from one OTRS server to another
Moderator: crythias
-
- 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
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...
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
OTRS Community 6.0.11
Debian 9.0
MariaDB
-
- Administrator
- Posts: 3983
- 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
Hi,
This won't work without development because you have to adjust all referenced foreign keys for states, users, etc.
- Roy
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 ?
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 ?
Re: Moving single queue from one OTRS server to another
Hi,
I thought it would not be easy.... I will keep queues as they are. Thanks for reply.
Tom
I thought it would not be easy.... I will keep queues as they are. Thanks for reply.
Tom
Re: Moving single queue from one OTRS server to another
Hi,
you can use webservices. But this needs development or commercial addons.
Florian
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.
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.