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 » 29 Feb 2012, 02:26

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 guru
Posts: 1025
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 » 29 Feb 2012, 22:58

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 » 04 Mar 2012, 03:03

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 » 06 Mar 2012, 11:50

i have the same problem. anyone?

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

Re: convert DB from MSSQL to MYSQL

Post by jojo » 06 Mar 2012, 11:51

this typically would require some development...
"Production": 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 :: Share your ideas

ferrosti
OTRS ninja
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 » 06 Mar 2012, 17:37

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 » 19 Mar 2012, 14:39

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 ninja
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 » 19 Mar 2012, 16:44

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