We performed a comparison between SAP HANA and SQL Server based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Because SAP HANA’s users say its pricing, support, and ease of deployment could all be greatly improved, SQL Server ultimately wins out in this comparison.
"SAP HANA is a stable solution."
"We can save data very easily."
"It is difficult for me to narrow down what the best features are in SAP HANA because they work together to provide the overall functionality of the solution. However, the Fiori application is very good."
"The product handles high volumes very well and provides good integration."
"Eases management of databases."
"In comparison with other DMS solutions, it offers good performance."
"A very feature-rich solution with excellent performance."
"The most valuable feature of SAP HANA is its performance and integration."
"The technical support that Microsoft provides is great."
"The initial setup was straightforward."
"The license fee is very low."
"I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it. You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers."
"Its usability is very good. Its performance is satisfactory."
"There is a lot of information about the solution readily available online."
"It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature."
"The support from Microsoft has been good."
"The solution's development platform should be more flexible and scalable to adapt to other solutions."
"I would like more technical documentation. I would like it to be easier to find online help or have a better launch-based service. SAP has a lot of functions, so we need more best practices and more detailed documentation on industry solutions. For example, it would be good to have documentation on why a certain process needs to be set up and which kinds of configurations need to be set up."
"It could be a bit more scalable."
"The initial setup was very, very complex, tedious, and costly and required someone with great expertise to complete it."
"In a future release, SAP HANA should add a module for taxation, such as income tax and withholding tax."
"It's a complex initial setup."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"It is challenging to integrate it with third-party tools."
"I want to see one improvement and this involves the replication between the DC and DR."
"SQL Server could improve by having better usability or user guidance."
"I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change."
"It would be better if it had more integration with other systems."
"I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server."
"They could improve by adding the SQL format."
"The price could be better. In the next release, it would be better if the database was more easily extendable."
"The scalability could be better."
SAP HANA, also known as SAP High-performance Analytics Appliance, is a multi-model database that stores data in its memory, allowing users to avoid disk storage. The product combines its robust database with services for creating applications. SAP HANA is faster than other database management systems (DBMS) because it stores data in column-based tables in main memory and brings online analytical processing (OLAP) and online transaction processing (OLTP) together.
The column-oriented in-memory database design allows users to run high-speed transactions alongside advanced analytics, all in a single system. This provides companies with the ability to process very large amounts of data with low latency and query data in an instant. By combining multiple data management capabilities, the solution simplifies IT, helps businesses with innovations, and facilitates digital transformation.
The solution is structured into five groups of capabilities, categorized as:
There are three more SAP products that work alongside SAP HANA and complete the experience for users together. SAP S/4HANA Cloud is a ready-to-run cloud enterprise resource planning (ERP). SAP BW/4HANA is a packaged data warehouse, based on SAP HANA, which allows users to consolidate data across the enterprise to get a consistent view of their data. Finally, SAP Cloud is a single database as a service (DBaaS) foundation for modern applications and analytics across all enterprise data. All three products can combine with SAP HANA to deliver to users an optimized experience regarding their data.
SAP HANA Features
Each architectural group of capabilities of SAP HANA has various features that users can benefit from. These include:
SAP HANA Benefits
SAP HANA provides many benefits for its users. These include:
Reviews from Real Users
According to a database consultant at a pharma/biotech company, SAP HANA is a very robust solution with good data access.
Bruno V., owner at LAVORO AUTOM INF E COM LTDA, likes SAP HANA because the product offers advanced features, helps reduce hours, and makes it easy to find what you need.
SQL Server is a relational database management system (RDBMS) by Microsoft. The product's main purposes are to store data and retrieve it as requested by other software applications - on the same computer or on another computer across a shared network. The solution is built on top of Structured Query Language (SQL), which is a standardized programming language used for relational database management.
The product is tied to Transact-SQL (T-SQL), which is an implementation of SQL from Microsoft that adds several proprietary programming extensions to the standard language. SQL Server is built similarly to other RDBMS products, as its structure is a row-based table that connects related data elements in different tables to one another. One of its most important components is the SQL Server Database Engine, as it controls data processing, storage, and security. Beneath the Database Engine is the SQL Server Operating System, which is used for memory and I/O management, locking data to avoid unneeded upgrades, and job scheduling.
The solution has four editions with different sets of services and tools. They include:
The first two are available for free and are typically utilized by smaller companies, as they work with fewer functions and storage. The second two editions are generally used by bigger organizations and enterprises and offer more features.
The solution has several functions through which users can facilitate different data-related processes. These include:
SQL Server Services
SQL Server has a wide range of add-on services that provide additional benefits beyond database management. These services include:
SQL Server Benefits
The solution has many benefits for users. These include the following:
Reviews from Real Users
A president at a consultancy evaluates SQL Server as a veteran solution with critical log shipping feature.
Harkamal S., a user at a manufacturing company, rates SQL Server with a high mark because it is a stable, scalable, and easy-to-deploy solution that pretty much covers everything.
SAP HANA is ranked 4th in Relational Databases Tools with 45 reviews while SQL Server is ranked 1st in Relational Databases Tools with 103 reviews. SAP HANA is rated 8.6, while SQL Server is rated 8.4. The top reviewer of SAP HANA writes "Good integration capabilities, easy to implement, and reliable". On the other hand, the top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". SAP HANA is most compared with Oracle Database, IBM Db2 Database, MySQL, Apache Spark and Teradata, whereas SQL Server is most compared with Oracle Database, MariaDB, LocalDB, IBM Db2 Database and Teradata. See our SAP HANA vs. SQL Server report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.