Hi there, We have installed OTRS on a FEDORA box and it's working great with mysql but we want to connect OTRS with MSSQL. We imported the DB from mysql into MSSQL just fine. The only info that we could find in connecting to MS SQL server is like in the lines below: $Self->{Server} =3D 'SQL Server'; # DatabaseDSN $Self->{DatabaseDSN} =3D"DBI:ODBC:driver=3D$Self->{Server};Server=3D$Self->{DatabaseHost};dat = abase=3D$Sel f->{Database};uid=3D$Self->{DatabaseUser};pwd=3D$Self->{DatabasePw};"; $Self->{'Database::Type'} =3D 'mssql'; Have I missed something? Any help would be appreciated, Thank You Sebastian
Integrity IT - Sebastian Seghete schrieb:
We have installed OTRS on a FEDORA box and it’s working great with /mysql/ but we want to connect OTRS with MSSQL.
I guess you won't succeed due to the available data types in MSSQL. Iirc, it's this: We need huge, searchable(!) TEXT fields (or varchar). MSSQL doesn't allow text data types to be bigger than 4096 byte, above this you have to use BLOBs and stuff, which aren't indexable nor searchable (correct me if I'm wrong). So, every email above 4k will blow your installation. Nonetheless, we had this discussion to some extent on this list. Search the archives please, and come back with more questions arizing. Regards, Robert Kehl
participants (2)
-
Integrity IT - Sebastian Seghete -
Robert Kehl