SOLVED: migrate database from otrs 6.0.29 to znuny 6.5.6

Moderator: crythias

Locked
rodolfor
Znuny advanced
Posts: 103
Joined: 11 Jun 2020, 14:56
Znuny Version: 6.5.8
Real Name: Rodolfo Rughi
Company: none

SOLVED: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by rodolfor »

Hi all.
I want to test the migration from otrs 6.0.29 to znuny 6.5.6.
I noticed some difference in database, mainly (I think) the introducion of table permission_groups.

In general, when I install a new version, the initial installer (if I select an existing db) updates also the database ?
Or, there are scripts to update the database from a version to another?

Thanks
Rod
Last edited by rodolfor on 23 Feb 2024, 16:43, edited 2 times in total.
gsalin
Znuny newbie
Posts: 39
Joined: 10 Mar 2023, 16:38
Znuny Version: znuny 6.5.8
Real Name: Gérald Salin
Company: INRAE - GeT-PlaGe

Re: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by gsalin »

you have to upgrade from one major version to another : 6.0 > 6.1 > 6.2 > 6.3 > 6.4 > 6.5
the procedure in the doc includes a step were the database is upgraded
--
znuny 6.5.8
postgresql
Rocky Linux
skullz
Znuny superhero
Posts: 658
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by skullz »

Migration script (scripts/MigrateToZnuny6_x.pl) will handle all this db things.

And if course u have to do 1 by 1. as mention above
My Github
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This

Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
rodolfor
Znuny advanced
Posts: 103
Joined: 11 Jun 2020, 14:56
Znuny Version: 6.5.8
Real Name: Rodolfo Rughi
Company: none

Re: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by rodolfor »

Thanks to gsalin and skullz suggestions, I found this document:

https://www.infiniroot.com/blog/1272/ho ... -znuny-lts
Johannes
Moderator
Posts: 425
Joined: 30 Jan 2008, 02:26
Znuny Version: All of them ^^
Real Name: Hannes
Company: Znuny|OTTERHUB

Re: SOLVED: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by Johannes »

You could also have a look at the docs:

https://doc.znuny.org/znuny_lts/releas ... pdate.html

8)

Best of luck!
dwtad
Znuny newbie
Posts: 3
Joined: 15 Jul 2024, 17:22
Znuny Version: 6.5.9 LTS
Real Name: Thomas

Re: SOLVED: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by dwtad »

Do I read the docs correctly that a migration from OTRS CE is not supported and not documented?

Thanks!
zzz
Znuny superhero
Posts: 914
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: SOLVED: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by zzz »

dwtad wrote: 16 Jul 2024, 16:52 Do I read the docs correctly that a migration from OTRS CE is not supported and not documented?

Thanks!
It is possible and documented. That's basically the first notice:
CE.png
You do not have the required permissions to view the files attached to this post.
Professional Znuny and OTRS services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
dwtad
Znuny newbie
Posts: 3
Joined: 15 Jul 2024, 17:22
Znuny Version: 6.5.9 LTS
Real Name: Thomas

Re: SOLVED: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by dwtad »

I don't know... It reads as if this is the description for upgrading from one Znuny version to the next. Which doesn't affect me since I started with 6.5.9 LTS. What I do want however is migrate the tickets and settings from an existing OTRS CE installation.
zzz
Znuny superhero
Posts: 914
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: SOLVED: migrate database from otrs 6.0.29 to znuny 6.5.6

Post by zzz »

I mean, the doc states that it's possible and every answer in this topic states the same information — including mine, which was directed to you.

I am not sure where the presumption that migrating from OTRS 6 (Community Edition) is not possible comes from.

Znuny offers a native way to migrate from OTRS 6 or Znuny 6.0.x LTS to Znuny 6.1.x. In this case, update also means migrate. Is the wording the issue?
Professional Znuny and OTRS services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
Locked