It really depends on the purpose of usage. Both have strengths and limitations. SAP HANA is expensive especially when you try to integrate data from other sources than SAP systems. SQL Server (I believed you refer to MSSQL), is good for you to store application data. However, if you need big data analysis or advanced analytics, SQL Server may not be the best solution. The same goes for SAP HANA.
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.
Ease of Deployment: Users of both solutions feel their initial setup is mostly straightforward with some complexity. SAP HANA users mention more difficulties, however, and note that it’s really complex if you’re migrating from another system.
Features: Users of both products are generally happy with their...
It really depends on the purpose of usage. Both have strengths and limitations. SAP HANA is expensive especially when you try to integrate data from other sources than SAP systems. SQL Server (I believed you refer to MSSQL), is good for you to store application data. However, if you need big data analysis or advanced analytics, SQL Server may not be the best solution. The same goes for SAP HANA.