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 <mailto:dave.shell...@te.com> dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 <http://www.te.com/> <http://twitter.com/teconnectivity> <http://www.facebook.com/teconnectivity> <http://www.flickr.com/photos/teconnectivity/> <http://www.linkedin.com/groups?gid=1591657> <http://www.youtube.com/teconnectivity> _attend WWRUG12 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"
<<image001.gif>>
<<image002.png>>
<<image003.png>>
<<image004.png>>
<<image005.png>>
<<image006.png>>
