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___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
