Hello,
i want to move my OTRS 3.2.6 running on windows server with mysql to OTRS Appliance 3.3.4.
OTRS Appliance ist installed and working perfectly.
The old OTRS-installation runs with mysql.
The OTRS-appliance runs with postgresql.
Now i want o import all exisiting data from my old OTRS to the appliance database.
i export mysql-data with:
mysqldump -u otrs -p OTRS --compatible=postgresql --default-character-set=utf8 > otrs_exp.sql
i add following lines into the export-file:
SET standard_conforming_strings = 'off';
SET backslash_quote = 'on';
i import the sql-file into postgres:
psql -h localhost -p 5432 -d otrs -U otrs -W -f /home/otrs_exp.sql
what i get are millions of syntax-errors.
use the escape string syntax example: E'\r\n'
Is there any script to migrate from mysql to postgresql written by otrs ? would be cool
or ist there any mysql/postresql hero who can help me out of that problem ?
thx greetz Stefan
Update: I found something ... try this first: https://github.com/lanyrd/mysql-postgresql-converter
dont work - get an error on line 184
Move windows otrs to otrs appliance
Moderator: crythias
Re: Move windows otrs to otrs appliance
Another tool to try DBSync
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Move windows otrs to otrs appliance
http://en.wikibooks.org/wiki/Converting ... PostgreSQL
There's a script to change the escape characters.
Disclaimer: I'm just pointing to a link. I don't have any position on its veracity.
There's a script to change the escape characters.
Disclaimer: I'm just pointing to a link. I don't have any position on its veracity.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Move windows otrs to otrs appliance
I am having the same problem migrating from 4.0.5 to appliance.
@StefanP: Do you found a solution for it?
@StefanP: Do you found a solution for it?
Last edited by xadox on 10 Jul 2015, 13:34, edited 1 time in total.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Move windows otrs to otrs appliance
Also no particular reason you can't install MySQL on the appliance, I would think..
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask