SAP HANA vs SAP SQL Anywhere

• Multi Store Tables - allowing to store data in default store and extended store as per data ageing.
• In Production Environment it allows same host deployments (Hana host + Dynamic Tiering). No need to have separate dedicated server for each of them.
• Incremental and differential backups - Reducing backup times and storage requirements.

Read full review

• The ability to host network database services and the ability to manage them.

Read full review

• Support - hard to find resources online so you are often dealing with an issue for a while.
• UI could be more intuative, takes a while to get use to or train users.
• Using a couple of models can make it not respond effectively.
• Doesn't support text data type.

Read full review

• I think it should be more user friendly for non-technical users.
• More functional functionalities should be added to the object explore when working with a table to transform data/manipulate data.

Read full review

• The [strategies] and the time consumed on migrating to HANA was time [consuming] and costly during the initial phases of the project.
• The time and resources utilized to set up the infra plan from requirements to production was huge.
• But once we were getting into cadence of utilizing the open architecture of HANA we were able to utilize its features that helped us to leverage.
• Again I would say that overall for us HANA [has] proved to be worth spending for as it helped us achieve our business's objectives.

Read full review

• Skilled/experienced resources are less prominent than Microsoft SQL Server or even Oracle, or MySQL, so finding solutions and assistance, if needed, takes more time than it would with other platforms
• You will need to find a good SQL query tool by yourself because the Sybase Central / Interactive SQL utilities are lacking in many basic features, and just generally have a bad user interface

Read full review