Migrate MSSQL to MySql

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Migrate MSSQL to MySql

Post by aph »

Hello All,

I'm mirating our OTRS windows + MSSQL installation to CentOS + MySQL. I was able to transfer dynamic fields and most of the SysConfig. I tried migrating the MSSQL database using the MySQL migration wizard, but the new DB does not have any articles listed under the ticket. From what I understand this is because of different structures of MSSQL and MySql. How do I go about migrating the tickets from the MSSQL DB to MySQL? Is there a way to achieve 1:1 data migration? What other ways can I transfer tickets from old system to new system?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Migrate MSSQL to MySql

Post by jojo »

We can do this as a consulting service for you...
"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
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Migrate MSSQL to MySql

Post by aph »

Thanks ;)
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Locked