IT Central Station is now PeerSpot: Here's why

SAP Adaptive Server Enterprise vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Buyer's Guide
SAP Adaptive Server Enterprise vs. SQL Server
May 2022
Find out what your peers are saying about SAP Adaptive Server Enterprise vs. SQL Server and other solutions. Updated: May 2022.
610,190 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""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."

More SAP Adaptive Server Enterprise Pros →

"The solution is easy to set up.""It works fine in terms of performance and stability.""They have improved the UI and ease of accessing the database and server which is good. You can load it up and start using it from the very minute it is implemented.""The solution seems to be pretty flexible.""It is integrated with Microsoft tools.""The most valuable feature of SQL Server is the performance.""The solution is stable. It's reliable.""The main feature of this solution is ease of use."

More SQL Server Pros →

Cons
"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.""User interface could be more user friendly.""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."

More SAP Adaptive Server Enterprise Cons →

"In terms of exceptionally large databases, it doesn't scale as well as Oracle.""They could improve the solution by allowing more portability between on-premise and the cloud.""More things in SQL Server need to be automated.""The remote access aspect needs to be improved in terms of security.""The interface could be updated to make it slightly more user-friendly.""Security is an issue.""The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient.""There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product."

More SQL Server Cons →

Pricing and Cost Advice
Information Not Available
  • "SQL Server is a cost-effective solution for a small database."
  • "Pricing is reasonable for small organizations, but the scaling increases the price."
  • "We didn't have any licensing costs for SQL Server."
  • "We pay approximately $12,000 USD per month for both the server and the license."
  • "The price could be cheaper."
  • "Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    610,190 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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… more »
    Top Answer:The setup cost is a bit expensive, but the pricing and licensing are just right.
    Top Answer: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… more »
    Top Answer:We're satisfied with the stability.
    Top Answer:Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.
    Ranking
    15th
    Views
    1,832
    Comparisons
    1,027
    Reviews
    3
    Average Words per Review
    370
    Rating
    8.0
    1st
    Views
    20,767
    Comparisons
    16,003
    Reviews
    171
    Average Words per Review
    451
    Rating
    8.2
    Comparisons
    Also Known As
    SAP ASE
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    With SAP Adaptive Server Enterprise (SAP ASE), you can handle massive volumes of data and thousands of concurrent users to accelerate the growth of new data-driven business applications. Drive value with a faster, more efficient transactional system that is designed to meet the demands of the digital economy.

    SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

    Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

    Offer
    Learn more about SAP Adaptive Server Enterprise
    Learn more about SQL Server
    Sample Customers
    City of Buenos Aires, ASR Group, Citrix, EarlySense, Usha International Limited, Automotive Resources International (ARI), Takisada-Osaka Co. Ltd., Coelba (Grupo Neoenergia), RZD Russian Railways, National Basketball Association - NBA, TALLY
    Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company30%
    Comms Service Provider11%
    Financial Services Firm9%
    Manufacturing Company6%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Comms Service Provider22%
    Computer Software Company22%
    Financial Services Firm8%
    Government6%
    Company Size
    REVIEWERS
    Small Business29%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise12%
    Large Enterprise74%
    REVIEWERS
    Small Business43%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise16%
    Large Enterprise64%
    Buyer's Guide
    SAP Adaptive Server Enterprise vs. SQL Server
    May 2022
    Find out what your peers are saying about SAP Adaptive Server Enterprise vs. SQL Server and other solutions. Updated: May 2022.
    610,190 professionals have used our research since 2012.

    SAP Adaptive Server Enterprise is ranked 15th in Relational Databases with 3 reviews while SQL Server is ranked 1st in Relational Databases with 172 reviews. SAP Adaptive Server Enterprise is rated 8.0, while SQL Server is rated 8.2. The top reviewer of SAP Adaptive Server Enterprise writes "Provides integration and ease of access to reporting; UI could be more user friendly". On the other hand, the top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". SAP Adaptive Server Enterprise is most compared with SAP HANA, IBM Db2 Database, Oracle Database, SAP SQL Anywhere and SAP IQ, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, IBM Db2 Database and MariaDB. See our SAP Adaptive Server Enterprise vs. SQL Server report.

    See our list of best Relational Databases vendors.

    We monitor all Relational Databases 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.