Jose,
This is a good explanation on how to accomplish this in Oracle. However, I would really caution going down this path if you do not understand the database side and remedy tables on the backend. Your recommendation for FTS is as you say the best option. One slight update though to your article FTS is no longer separately licensed in 7.6.04. We went back and forth on a client site recently to make the database changes and ultimately chose the FTS route because the risk of updating and maintaining the indexes was too high. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Wednesday, February 29, 2012 12:18 AM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** No performance hits in Oracle if you follow my post: http://theremedyforit.com/2011/12/case-insensitive-in-remedy/ Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 <http://www.sm2baleares.es/> SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca <http://es-es.facebook.com/pages/SM2-Baleares/158608627954> <http://twitter.com/#!/SM2Baleares> <http://www.linkedin.com/company/sm2-baleares> La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Feb 29, 2012 at 06:04, Brian Pancia <panc...@finityit.com> wrote: ** Dave, Sorry. I wasn't trying to come across as comparing which is better, but after re-reading my post it doesn't directly answer your question. I have not found any major gotchas with MS SQL. Oracle case sensitivity has always been an issue. You can set flags at the db level to change that, but then you are risking performance hits. Tommy, I have seen some issues with how FTS performs certain searches like wildcard searches. It's been a few months since I've messed with FTS. I'll see if I can dig up my notes from an installation we did that we ended up doing a bunch of tweaks to FTS. FTS has been around for a long time now, so I'm sure a bunch of people can chime in on FTS tips and tricks. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Tuesday, February 28, 2012 4:57 PM To: arslist@ARSLIST.ORG Subject: Re: MS SQL question ** Brian, I understand. As I said I'm not asking which is better. I'm attempting to understand if there are any hidden gotchas with MS SQL like there is with Oracle. There my not be any but that is what I want to identify. Thanks Dave On Feb 28, 2012, at 4:51 PM, "Brian Pancia" <panc...@finityit.com> wrote: ** 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:%2B1%20717%20810%203687> tel +1 717 810 2124 <tel:%2B1%20717%20810%202124> fax <mailto:dave.shell...@te.com> dave.shell...@te.com MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 <http://www.te.com/> <image001.gif> <http://twitter.com/teconnectivity> <image002.png> <http://www.facebook.com/teconnectivity> <image003.png> <http://www.flickr.com/photos/teconnectivity/> <image004.png> <http://www.linkedin.com/groups?gid=1591657> <image005.png> <http://www.youtube.com/teconnectivity> <image006.png> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _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.jpg>>
<<image002.jpg>>
<<image003.jpg>>
<<image004.jpg>>
