Migration - how to export and import tickets only ?

Moderator: crythias

Locked
rzanon
Znuny newbie
Posts: 9
Joined: 17 Feb 2014, 15:47
Znuny Version: 3.3.4
Real Name: Romain ZANON
Company: Tyredating
Location: Lyon, FRANCE

Migration - how to export and import tickets only ?

Post by rzanon »

Hi there,

I cloned my prod server in order to perform some tests on it. I patched it from 3.3.1 to 3.3.4, installed ITSM and created new queues, customer users, company and groups. I haven't made any change on ITSM at this time.

Now, I would like to use this server as prod server. However some new tickets have been creating in the meanwhile.

I would like to import these tickets (or all off them), with contents (notes and replies), in my new OTRS server but I would like to keep my changes made.

How can I do that? I guess it is not enough to just delete, recreate and import the ticket table? Which tables need to be imported or updated?

Is there an easy way to do it? Or maybe a module/add-on?

Thanks.
OTRS version 3.3.4
ITSM version 3.3.4
MySQL Server 5.1
OS : GNU/Debian 6 Squeeze
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Migration - how to export and import tickets only ?

Post by jojo »

this is not possible. You have to migrate the old database and then do your modifications
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked