convert DB from MSSQL to MYSQL

Moderator: crythias

Post Reply
waikiki83
OTRS newbie
Posts: 28
Joined: 25 Jul 2011, 09:15
OTRS Version?: 3.0.9

convert DB from MSSQL to MYSQL

Post by waikiki83 »

hello guys need your help once again...
we are trying to migrate our db from MSSQL to MYSQL
we bought a tool for migration and the migration went smoothly
however, when the details of the tickets are shown in OTRS it is garbage.
all other data have no problem subject of emails, sender, etc...

and when i use the mysql workbench to view the article details or body i could see the body of the email just fine.

on the mssql database we are using iso-8859-1 as default charset.

any clue or idea on whats going on?
OTRS 3.3.1 Windows Server 2008, Apache, MS SQL Server 2008

Wolfgangf
OTRS ninja
Posts: 1029
Joined: 13 Apr 2009, 12:26
OTRS Version?: 6.0.13
Real Name: Wolfgang Fürtbauer
Company: PBS Logitek GmbH
Location: Pinsdorf

Re: convert DB from MSSQL to MYSQL

Post by Wolfgangf »

have you tried the tools from mysql for converting?
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting

mulder33
OTRS newbie
Posts: 1
Joined: 04 Mar 2012, 02:59
OTRS Version?: 10001
Contact:

Re: convert DB from MSSQL to MYSQL

Post by mulder33 »

Wolfgangf wrote:have you tried the tools from mysql for converting?
I would try this as well...
Everything you need to know about Windows Tablets.
Read this article on, Microsoft Surface vs iPad: Advantages and Disadvantages.

lacompostela
OTRS newbie
Posts: 1
Joined: 06 Mar 2012, 11:48
OTRS Version?: latest
Real Name: Lacompostela
Company: Lacompostela
Contact:

Re: convert DB from MSSQL to MYSQL

Post by lacompostela »

i have the same problem. anyone?

jojo
Moderator
Posts: 14779
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: convert DB from MSSQL to MYSQL

Post by jojo »

this typically would require some development...
"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

ferrosti
OTRS superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: convert DB from MSSQL to MYSQL

Post by ferrosti »

mssql database we are using iso-8859-1 as default charset
Do you have mySQL configured to use the same codepage as default, as well as your tables codepage?
Submit a

Code: Select all

SHOW CREATE TABLE article_plain;
and see the last line.

BTW: OTRS starting at 3.0 should per default use UTF-8!
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems

waikiki83
OTRS newbie
Posts: 28
Joined: 25 Jul 2011, 09:15
OTRS Version?: 3.0.9

Re: convert DB from MSSQL to MYSQL

Post by waikiki83 »

Do you have mySQL configured to use the same codepage as default, as well as your tables codepage?
Submit a

Code: Select all

SHOW CREATE TABLE article_plain;
and see the last line.

BTW: OTRS starting at 3.0 should per default use UTF-8![/quote]

Thanks for the command and i found out that it is using UTF-8.
Do you have any idea on how i can convert this to ISO-8589-1.
Apparently, the default coding in MSSQL is ISO.

Thanks in advance....
OTRS 3.3.1 Windows Server 2008, Apache, MS SQL Server 2008

ferrosti
OTRS superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: convert DB from MSSQL to MYSQL

Post by ferrosti »

There were enough hints by others in this thread! Go for the mySQL tools.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems

Post Reply