Solved: Migration from Windows to Linux

[RBehr]

We need to migrate an OTRS installation from Windows Server 2003 to Ubuntu 10.04.

We have successfully set up OTRS on the Ubuntu server. What would be the best method of transferring the config files from the Windows server to the Ubuntu server? We wish to continue to use a SQL Server 2005 database.

Many thanks

[Wolfgangf]

Admin -> Sysconfig -> Download Settings on Windows Installation
Admin -> Sysconfig -> Load Settings on Linux Installation

[jojo]

An MS SQL Database can not be used as application datbase on a linux based installation! (Only via ODBC, but this combination won't be supported)

[MichaelR]

The major change is you will need to dump the MS SQL database and somehow convert it to MySQL or some other database that is supported in Linux.

[RBehr]

So a Ubuntu / Linux installation does not support SQL Server? No way around this?

[Wolfgangf]

you can connect to a MS/SQL server on a different host; MS/SQL does not run under Linux
if you want to have everything on Linux, you might want to use MySql and need some export / migration script from MS/SQL to MySql (which is not to hard to do)
You would have to write a script, which runs through all tables in MSSQL and insert every record/field into MySql

Hope that helps

[RBehr]

Thanks for the feedback. Because we need to stay on SQL Server, we have chosen to remain with Apache running on a Windows Server. Performance isn't great, but its acceptable.