If you are new to both Microsoft SQl server and as well as Oracle database server, you may think that both the database server are very much similar to each other, however, both are similar to a certain degree. Moreover, each has their own unique features and functionality and differ each other in many perspectives.
It is always a doubt and perplex for anyone for many years regarding what database platform to choose between these two platforms of Sql and Oracle because both have different features respectively. But that’s not really where the real importance lies; the important thing is the database server effective and user-friendly in handling the database every time with a high-end security system to their database. However, in this article, I will give a brief discussion about the real difference between sql & oracle and comparison Sql and Oracle the two giant database servers today.
Supported Operating Systems:
Microsoft Sql server has always been an integral part associated with Windows server family and so far Microsoft has not come up with any version of the database that can be applied in other OS than windows. The operating system supported by Microsoft Sql server database is XP, Vista, Windows Server 2000, 2003 and 2008. The database platform is available for both 32 bit and 64 bit versions of Windows.
Whereas with Oracle supports multi-platform OS support which includes Windows (32 bit and 64 bit), Linux and as well as UNIX platform (Solaris, HP-UX, AIX etc.)
Both the database server provides high-end security system for the client’s database and however, experts claim that Microsoft Sql server provides much more security compared to that of Oracle as many security vulnerability cases have been filed against Oracle compared to Sql. Microsoft Sql advanced security is incorporated in all Standard, Enterprise, and Workgroup SQL Server Editions whereas Oracle has come up only with a basic level of security regarding their standard and enterprise editions.
Both Oracle and Sql server often comes up with frequent updates of new features for the clients to handle the database effectively. The new features that is included with Oracle latest version of Oracle 11g is the Pl/Sql as it is an essential 3GL that was designed especially regarding the flawless processing of SQL commands. Moreover, it also provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database.
Latest SQL Server of version 2008 well supports the ADO.NET Entity Framework and the reporting tools, replication, and data definition will be built around the Entity Data Model.
Some of the major DBA duties of Oracle database is to implement and maintain database security and as well as to Do application tuning and performance monitoring. Moreover, they also install, patch and maintain all Oracle software. In SQL server the major DBA duties are to Installation, configuration and upgrading of SQL server software and related products.
If you are working on both databases then you should need to take care of both servers, applications, databases.
Myths-Mysteries-Memorable 