We performed a comparison between SAP Adaptive Server Enterprise and SQL Server based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment."
"They provide easy integration with other systems."
"It's user-friendly, especially in the logistics field."
"SAP Adaptive Server Enterprise is a good transactional database."
"The actual interface is good."
"Provides very good integration."
"I like that SAP ASE can match code and the database index to index data in the programming language. There are many other valuable features, such as the table buffer, tuning, and various control agents like dispatcher. SAP ASE can handle many different data types, including views, domains, data elements, structures, objects, and various table types that are most useful in the application. Its modularization technique is also handy."
"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."
"The ability to see tables, reviews, and custom script options is good."
"We have many users, between 50 and 100 using the SQL Server product."
"This solution is user-friendly and easy to understand."
"If you need to, you can scale the solution very easily."
"SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful."
"The Always On tool improves the SQL server availability."
"I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else."
"SAP should refine its debugging method, and the process needs to be a little faster. It should use more Pragmas and fewer pseudocomments. I would like if SAP added more features based on advanced technologies, like artificial intelligence and voice control. The modularization and if-else techniques could also incorporate the latest technology to code and solve complex problems. The SAP Editor should be more elaborative, and it should allow many more types of statements for all uses."
"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"I think that the solution needs to be positioned better within the market as it appears as though the Adaptive Server is being left out of the SAP scope."
"There could be some improvements in barcode scanning and RFID access."
"Cost-wise, SAP is still expensive compared to other available products."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"User interface could be more user friendly."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"Support could be improved."
"Performance could be improved."
"Query optimitzer could be simplified."
"Third-party services from Redgate should be built-in to it, like SQL Search."
"It would be better if it had more integration with other systems."
"They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive."
"Better integration with other platforms would be an improvement."
More SAP Adaptive Server Enterprise Pricing and Cost Advice →
SAP Adaptive Server Enterprise is ranked 17th in Relational Databases Tools with 10 reviews while SQL Server is ranked 1st in Relational Databases Tools with 259 reviews. SAP Adaptive Server Enterprise is rated 8.6, while SQL Server is rated 8.4. The top reviewer of SAP Adaptive Server Enterprise writes " Loaded with a lot of features but the price is a drawback ". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SAP Adaptive Server Enterprise is most compared with SAP HANA, SAP SQL Anywhere, Oracle Database, IBM Db2 Database and SAP IQ, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database and LocalDB. See our SAP Adaptive Server Enterprise 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.