A large benefit you will get moving to MSSQL Server is the use of stored procedures to return results sets through Set Fields action. This not allowed in Oracle so you have to hard code SQL statements.
On 12/5/06, Rick Cook <[EMAIL PROTECTED]> wrote:
** I can't even remember seeing an option to install MS SQL as case-insensitve for at least a couple of versions. When it was there, it was still tied to Sybase (i.e. v6), where you simply selected a dataset that fit your needs, and selected your case sensitivity once and for all at that time. What version of SQL are you using? Rick On 12/5/06, CONDREA, Daniel <[EMAIL PROTECTED]> wrote: > > ** > Is MSSQL really case insensitive? > > It depends how it installed. > > Here is case sensitive > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto:[email protected] > ] *On Behalf Of *Axton > *Sent:* 05 December 2006 17:10 > *To:* [email protected] > * Subject:* Re: Database > > > ** > Is MSSQL really case insensitive? > Yes > > > We have several stored procedures in ORACLE. How flexible is MSSQL > when it comes to stored procedures? > The stored procedures are very capable, but the code does not transport > between the two RMDBS systems you referenced. You will have to rewrite the > sp's. > > > I have heard many say the Windows is not as stable as UNIX. How stable > is MSSQL? > My personal experience has been that, on MS, the more you install, the > less stable the system becomes. In corp/institutional environments, this > roughly translates to, the more groups you have involved in managing your > servers, the less stable they are. In the shops where my group managed the > servers from the wall out, windows was rock solid. In the shops where there > was a storage group, an OS group, a security group, a hardware group, a > network group, an hp group, an oracle group, and many other groups involved > in the management of the system, the thing continually falls apart. > > Axton Grams > > On 12/5/06, David Yearsley <[EMAIL PROTECTED] > wrote: > > > > ** Our current environment has included a ORACLE database more than 6 > > years. Our hardware is reaching the end of its life and because of Price and > > the Case Sensitivity of ORACLE we are looking at possibly replacing ORACLE > > with Microsoft SQL. > > > > As we investigate this change there are several questions I would like > > to ask. > > > > Is MSSQL really case insensitive? > > > > > > We have several stored procedures in ORACLE. How flexible is MSSQL > > when it comes to stored procedures? > > > > > > I have heard many say the Windows is not as stable as UNIX. How stable > > is MSSQL? > > > > > > Has anyone made the switch from ORACLE to MSSQL? If so, do you have > > any advice? > > > > > > Any information we are overlooking? > > __20060125_______________________This posting was submitted with HTML > > in it___ > > > __20060125_______________________This posting was submitted with HTML in > it___ > __20060125_______________________This posting was submitted with HTML in > it___ > > > -- > > *****DISCLAIMER***** > > The information contained in this communication is confidential and may > be legally privileged. It is intended solely for the use of the individual > or entity to whom it is addressed and others authorized to receive it. If > you are not the intended recipient you are hereby notified that any > disclosure, copying, distribution or taking action in reliance of the > contents of this information is strictly prohibited and may be unlawful. > Orange Romania S.A. is neither liable for the proper, complete > transmission of the information contained in this communication nor any > delay in its receipt. > > *****END OF DISCLAIMER***** > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" __20060125_______________________This posting was submitted with HTML in it___
-- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
