Move windows otrs to otrs appliance

[StefanP]

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

[Loki555]

Another tool to try DBSync

[crythias]

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.

[xadox]

I am having the same problem migrating from 4.0.5 to appliance.
@StefanP: Do you found a solution for it?

[crythias]

Also no particular reason you can't install MySQL on the appliance, I would think..