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.
"The solution is easy to manage enterprise resources and the reporting and analytics are including. It is good for company growth and all module are managed well."
"The feature that I like the most is that we can transport the data to our web data application. SAP HANA's performance is really perfect. We're working on big data, and SAP HANA is really working on high performance. We are happy working with it."
"It is very stable and very innovative. You can integrate many applications with it."
"The speed at which it gets the data is great."
"We like that the product is both vertically and horizontally scalable, allowing us to do around 86 percent compression of documentation from 50 to seven terabytes."
"SAP HANA's most valuable features are monitoring, reporting, and price and stock control."
"We have found that the Fiori Apps are particularly good."
"It's sufficed all of our requirements. We primarily needed it to run SAP applications, like NetWeaver or S/4HANA, and it has been really good at that."
"It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage."
"The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete."
"The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL profiler and SQLCMD as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly."
"A big advantage is the ability to store any type of data in SQL Server."
"The product has been on the market for over 25 or 30 years. It's an extremely mature solution."
"It is stable, and it works okay."
"It is easy to use and very stable."
"The interface for building the queries or writing the store procedures is good."
"The solution could improve in the handling of backup data and the administration tools."
"The product is very demanding on memory requirements."
"The performance and integration with other products are areas in need of improvement."
"The pricing is expensive."
"The solution could improve by having better migration flexibility. For example, it would be helpful if there was a way for customers could check their nonproduction and production deployments."
"It is challenging to integrate it with third-party tools."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"The solution is very expensive, however. The pricing depends on the number of users and many other factors that affect licensing."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."
"I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"If you are a new user then this solution could be difficult, they could improve by making the overall usage easier."
"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."
"In terms of improvement, it could use more integration with other products."
"I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups."
SAP HANA is ranked 3rd in Relational Databases Tools with 81 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. SAP HANA is rated 8.4, while SQL Server is rated 8.4. The top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SAP HANA is most compared with Oracle Database, MySQL, IBM Db2 Database, Apache Spark and SAP Adaptive Server Enterprise, whereas SQL Server is most compared with MariaDB, Oracle Database, 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.