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?
convert DB from MSSQL to MYSQL
Moderator: crythias
convert DB from MSSQL to MYSQL
OTRS 3.3.1 Windows Server 2008, Apache, MS SQL Server 2008
-
- Znuny ninja
- Posts: 1029
- Joined: 13 Apr 2009, 12:26
- Znuny Version: 6.0.13
- Real Name: Wolfgang Fürtbauer
- Company: PBS Logitek GmbH
- Location: Pinsdorf
Re: convert DB from MSSQL to MYSQL
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
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
Re: convert DB from MSSQL to MYSQL
I would try this as well...Wolfgangf wrote:have you tried the tools from mysql for converting?
Everything you need to know about Windows Tablets.
Read this article on, Microsoft Surface vs iPad: Advantages and Disadvantages.
Read this article on, Microsoft Surface vs iPad: Advantages and Disadvantages.
-
- Znuny newbie
- Posts: 1
- Joined: 06 Mar 2012, 11:48
- Znuny Version: latest
- Real Name: Lacompostela
- Company: Lacompostela
- Contact:
Re: convert DB from MSSQL to MYSQL
i have the same problem. anyone?
Re: convert DB from MSSQL to MYSQL
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny superhero
- Posts: 723
- Joined: 10 Oct 2007, 14:30
- Znuny Version: 3.0
- Location: Hamburg, Germany
Re: convert DB from MSSQL to MYSQL
Do you have mySQL configured to use the same codepage as default, as well as your tables codepage?mssql database we are using iso-8859-1 as default charset
Submit a
Code: Select all
SHOW CREATE TABLE article_plain;
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
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
Re: convert DB from MSSQL to MYSQL
Do you have mySQL configured to use the same codepage as default, as well as your tables codepage?
Submit a
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....
Submit a
Code: Select all
SHOW CREATE TABLE article_plain;
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
-
- Znuny superhero
- Posts: 723
- Joined: 10 Oct 2007, 14:30
- Znuny Version: 3.0
- Location: Hamburg, Germany
Re: convert DB from MSSQL to MYSQL
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
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