Query from another old otrs database

Moderator: crythias

Locked
JojoModjo
Znuny newbie
Posts: 38
Joined: 17 Mar 2016, 12:29
Znuny Version: 5.0.14
Real Name: Joseph Munyao
Company: Diamond Trust

Query from another old otrs database

Post by JojoModjo »

HI All,

I want to try something ambitious, i recently installed a new clean otrs 5.1 server and we have been using an old otrs 3.1.1 server. What i want to do is to link the old database to the new database so that someone can search for the old tickets logged in the 3.1.1 from the new 5.1 server.
i would like to do this without copying data from the old database to the new database.
Is this possible and how?
To whom much is given, much is expected from.

OTRS 5.0.14 | Newbie :D | Glad to meet you all
root
Administrator
Posts: 4253
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Query from another old otrs database

Post by root »

Nice, can you provide me a download link to OTRS 5.1?

Ok, to be honest: accessing the old tickets is done by migrating them to the version you're using. Everything else needs custom development.
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 ?
JojoModjo
Znuny newbie
Posts: 38
Joined: 17 Mar 2016, 12:29
Znuny Version: 5.0.14
Real Name: Joseph Munyao
Company: Diamond Trust

Re: Query from another old otrs database

Post by JojoModjo »

root wrote:Nice, can you provide me a download link to OTRS 5.1?

Ok, to be honest: accessing the old tickets is done by migrating them to the version you're using. Everything else needs custom development.

hehehe sorry that was a typo, i meant 5.0.14. It seems i will have to just migrate the data then. Thanks for the help.
To whom much is given, much is expected from.

OTRS 5.0.14 | Newbie :D | Glad to meet you all
JojoModjo
Znuny newbie
Posts: 38
Joined: 17 Mar 2016, 12:29
Znuny Version: 5.0.14
Real Name: Joseph Munyao
Company: Diamond Trust

Re: Query from another old otrs database

Post by JojoModjo »

But i was wondering can the Core::MirrorDB module be used to serve this purpose.
mirror.PNG
You do not have the required permissions to view the files attached to this post.
To whom much is given, much is expected from.

OTRS 5.0.14 | Newbie :D | Glad to meet you all
root
Administrator
Posts: 4253
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Query from another old otrs database

Post by root »

The mirrordb settings are used for performance reasons. By using a replicated database search and stats using the mirror database.
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 ?
Locked