Upgrade from 3.0.9 to Version 4.0 and Migrate from MySQL to MSSQL

[vodafrog]

Hi Everyone,

we have version 3.0.9 of OTRS and have been using this now for over four years, this is running on a Windows 7 PC, with Apache and MySQL.

We would like to upgrade to the latest version and also take the opportunity to put this onto a Windows Server along with the data now being in Microsoft SQL Server 2008 R2 or 2012.

Can anyone point me to the relevant upgrade path(s) and what needs to be done to perform the upgrade.

We will be installing OTRS onto a new platform so need to know how to migrate over from one environment to the other....

[jojo]

I strongly advice not to use MS SQL as application database. You'll experience performance issues

[vodafrog]

I strongly advice not to use MS SQL as application database. You'll experience performance issues

Hi jojo

what sort of performance issues would there be; are there any test/figures that have compared the two ?

[jojo]

there is only ODBC for connection so it will be really slow.