When we face any interview, then, we are mostly asked questions on SQL Server. One such question is,
Que: What is the Difference between SQL Server, Oracle and DB2?
In this article, I am demonstrating the difference between the three.
- Windows OS, DotNet and SQL Server are all products of Microsoft, and there is a tight integration between these products that provides a fast access to the data from the SQL Server on Windows Operating System from a DotNet Application, when compared to Oracle and DB2.
- SQL Server provides a Graphical User Interface to Perform Various operations on the Database. The GUI makes it easy to work with the database. But Oracle doesn’t provide Support for the GUI. For e.g., Oracle doesn’t provide the GUI, but the SQL Server provides GUI of any syntax of the command. It is to be noted that DB2 also Provides the GUI.
- The License of Oracle and DB2, for only 10 Users, requires 2 Lakhs, whereas SQL Server requires approx. 2 to 3 Lakhs for unlimited users. So, that means that the cost of the SQL Server is lower than that of the Oracle.
- The SQL Server comes as a bundle, containing a Minimum of 4 Products.
- Database Engine - Used to work with database.
- Analysis Services - Used the work with the data warehousing, data hiring.
- Reporting Service - To create Enterprise Report.
- Integration Services - Using to integrate the data from one data source to another, such as Oracle and SQL Server
All these 4 products are collectively called as MSBI (Microsoft Business Intelligence).
But in case of Oracle and DB2, you have to purchase them separately.
5. The drawback of the SQL server is that it is available for windows OS only and not for the Other
Operating Systems such as UNIX, LINUX and SOLARIS.
If you want to learn more about MSBI, then read my next article,
For more articles, visit my blog :
Amar GoalaPosted Jul 2, 2014, 8:43 AM
The SQL Server ODBC driver is available for LUNUX ,Unix OS..the SQL Server ODBC driver enables you to access SQL Server from applications running on Linux and UNIX platforms.SQL Server uses a protocol called Tabular Data Stream (TDS) for communication between client applications and SQL Server. Because TDS can be used over TCP/IP, remote client applications can communicate with SQL Server. It is not therefore necessary for client applications and SQL Server to run on the same machine. ODBC, which provides a standard way for applications to access databases, is one of the available client library APIs that can provide an interface toTDS. Microsoft has supported ODBC in all versions of SQL Server and has committed to continue to support ODBC in future versions of SQL Server. Microsoft’s SQL Server Native Client, which enables Windows client applications to access SQL Server, contains an ODBC driver. The SQL Server ODBC driver provides ODBC access to SQL Server for Linux and UNIX applications, and uses TDS to communicate with SQL Server. If you want to use SQL Server, but do not have any Windows machines at your site, you can use SQL Azure instead. SQL Azure provides database functionality as a pay-as-you-go utility service and is built on SQL Server technologies. Because SQL Azure uses Tabular Data Stream (TDS), client applications can use the same tools and libraries to access SQL Azure Database as they do to access SQL Server. The SQL Azure ODBC driver enables you to access SQL Azure from Linux and UNIX platforms.