Export/migrate data to new server

Moderator: crythias

Locked
ggirao
Znuny newbie
Posts: 37
Joined: 17 Sep 2014, 15:08
Znuny Version: 3.3.9
Real Name: Goncalo Girao

Export/migrate data to new server

Post by ggirao »

Hi,

I'm trying to export a MSSQL Server 2008R2 content from a windows 2008R2 running OTRS to a brand new Ubuntu with MySQL.

I successfully installed the new server and I just need to export the database (and settings) to this new server.

I tried directly from SQL Management Studio (with no success) and I'm starting to try with PentaHO Data Integration. Is there any easier way?

TY
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Export/migrate data to new server

Post by jojo »

"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
ggirao
Znuny newbie
Posts: 37
Joined: 17 Sep 2014, 15:08
Znuny Version: 3.3.9
Real Name: Goncalo Girao

Re: Export/migrate data to new server

Post by ggirao »

This isfor 4.0 only?


"Backend ERROR: OTRS-CGI-38 Perl: 5.18.2 OS: linux Time: Thu Mar 5 09:24:19 2015 Message: Sorry, can't install/upgrade package, because the framework version required by the package (4.0.x;) does not match your Framework (3.3.9)!"
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Export/migrate data to new server

Post by RStraub »

Well you didn't include your version :)

Check this page:
http://ftp.otrs.org/pub/otrs/packages/

You might try an older package.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
ggirao
Znuny newbie
Posts: 37
Joined: 17 Sep 2014, 15:08
Znuny Version: 3.3.9
Real Name: Goncalo Girao

Re: Export/migrate data to new server

Post by ggirao »

TY!

one (dumb) question. This package goes to new or old server?
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Export/migrate data to new server

Post by RStraub »

I don't know this package, just read from your error message that you were trying to install a too-new package on an older framework.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
ggirao
Znuny newbie
Posts: 37
Joined: 17 Sep 2014, 15:08
Znuny Version: 3.3.9
Real Name: Goncalo Girao

Re: Export/migrate data to new server

Post by ggirao »

Now I did install without issues (1.0.12)

Im reading TFM!

Your tips were very useful! :-)
Locked