Here Roy talks about the usability advantages MSSQL has and Oracle has not. The first common belief (and it is not true) is that Oracle is a better database engine, but MSSQL instead is more administrator/user friendly. And it is easier to develop in MSSQL. The truth is that Oracle lacks competitive development tools. Competitive - I mean in the Oracle field. You have to buy 3rd parties tools in order to be as productive as you could have been in MSSQL. Many companies produce TOAD and its price can reach 3000$ a license. So, is it true that Oracle database engine is better than that of MSSQL ? I don't think so. The point is that MSSQL's usability makes it possible to the people that lack database professional level write procedures and maintain the database server for longer time before the disaster happens (if ever). Only because of this fact, the average application built with Oracle seems more confident than the one built with MSSQL. IMHO, you have to learn a lot before you start to play with Query analyzer and Enterprize Manager. BTW, you have to know what's the major differences between Oracle database engine and MSSQL database engine. Know what optimizer is. So we talk about overusability here.
Friday, July 30, 2004 4:36 PM