I installed SRM and had FTS enabled, the SRM keyword search would not work. I disabled FTS and the search worked fine and was case insensitive. FTS has a problem with searching a LIKE "%value%". It will not work at all.
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Tuesday, February 28, 2012 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Dave, Case Sensitivity is not an issue with MS SQL. Also with 7.6.04 you have FTS, which provides better search capabilities for both Oracle and SQL. In my opinion MS SQL has come a long way in the last few releases and can stand up to Oracle as a true enterprise solution. I think a few years ago there were some valid reasons to go Linux(or flavor of Unix)/Oracle. Microsoft has come a long way though from both the OS and DB side of the house. I think now it just depends on the level of onsite expertise for your DB. I have set up multiple systems on both Oracle and MS SQL over the years and these days I find it much easier to go the Microsoft route. Both are rock solid if configured properly. If you have FTS configured properly it does relief some of the Oracle constraints, but it is something additional you would have to manage. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 2:00 PM To: arslist@ARSLIST.ORG Subject: MS SQL question ** I know that there are a couple of short comings with running the AR System on Oracle. Namely case sensitivity and searching a large character field. I'm wondering if there are short comings running on MS SQL. Not really looking for a debate on the advantages of one over the other. Just looking to see if MS SQL has any similar peculiarities. Thanks Dave Dave Shellman +1 717 810 3687 tel +1 717 810 2124 fax dave.shell...@te.com<mailto:dave.shell...@te.com> MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 [cid:image001.gif@01CCF631.6D1E8990]<http://www.te.com/> [cid:image002.png@01CCF631.6D1E8990]<http://twitter.com/teconnectivity>[cid:image003.png@01CCF631.6D1E8990]<http://www.facebook.com/teconnectivity>[cid:image004.png@01CCF631.6D1E8990]<http://www.flickr.com/photos/teconnectivity/>[cid:image005.png@01CCF631.6D1E8990]<http://www.linkedin.com/groups?gid=1591657>[cid:image006.png@01CCF631.6D1E8990]<http://www.youtube.com/teconnectivity> _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<inline: image001.gif>>
<<inline: image002.png>>
<<inline: image003.png>>
<<inline: image004.png>>
<<inline: image005.png>>
<<inline: image006.png>>
