Talley, Brooks schrieb:
I'm setting up an OTRS installation that will use an MS SQL backend for CustomerUser. So far, so good.
Robert Kehl write: Really?
Please search this list's archive for notes about MSSQL and it's failing tries to get into OTRS.
If you manage to get OTRS going on MSSQL to full extent, the community will durely be intertested in the database scheme used, and if you had any adaptions to do to the source code.
Yep, really. Mind you, this is just for CustomerUser, not for the entire OTRS backend. We are using MySQL for the main backend, and while we are hoping to move that to MSSQL also, we've determined that that is not critical, so if it can't happen we'll just live with it. The main thing was getting customer data integration, and that we have. It did take some work to get going, but all of the changes have been in Config.pm; no actual source code has been touched. We are still in the evlauation phase, so there may be gotchas that we haven't run into yet. Cheers -b