DB Migration from MS SQL to mysql

Moderator: crythias

Locked
danny0312
Znuny newbie
Posts: 70
Joined: 08 Nov 2013, 00:14
Znuny Version: OTRS 3.2

DB Migration from MS SQL to mysql

Post by danny0312 »

Hello everyone,

I recently completed a migration from MS SQL to mysql (currently on a testing server) using mysql workbench. Everything went fine except encoding. Most of the tables were showing latin1 collation so using these (viewtopic.php?f=62&t=16536) suggestions I converted it to utf8. Now all the table's collation as well as database is showing up as utf8. However, the content of the tickets wasn't converted properly and is still showing up as shown on a screenshot. If you have any hints or suggestions on how to fix it or maybe there is a conversion tool some one used before I will be thankful.
You do not have the required permissions to view the files attached to this post.
Version: OTRS & ITSM 3.3.8
OS: Windows Server 2012
DB: MS SQL 2012
Web Server: IIS 8
Locked