Coming October 25: PeerSpot Awards will be announced! Learn more

SQL Server vs Teradata comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
23,347 views|17,659 comparisons
Teradata Logo
13,007 views|10,508 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SQL Server and Teradata 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.

To learn more, read our detailed SQL Server vs. Teradata report (Updated: September 2022).
635,513 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it.""It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature.""SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm.""SQL Server's performance is fine.""The initial setup isn't overly complex.""It's great that the nodes are synchronized so if you lose one it automatically moves to another.""Since we can automate most of our tasks, it means that the management is very easy."

More SQL Server Pros →

"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running.""It's a pre-configured appliance that requires very little in terms of setting-up.""There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems.""The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers.""The performance is great, we are able to query our data in one operation.""I've never had any issues with scalability.""It's very, very fast""Teradata's most valuable feature is that it's easy to use."

More Teradata Pros →

Cons
"Their datatypes need improvement.""The treatment of database storage could be improved.""SQL Server could improve by being more user-friendly, it is still geared towards specialists. Additionally, the monitoring system is difficult to use, not everyone can use it well. The configuration should be able to be done through the GUI.""It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load.""The licensing costs are very high.""The scalability could be better.""The solution needs to be more secure. It's lacking, compared to, for example, Oracle.""It would be great if we were able to run it on multiple operating systems and not only stick with Windows."

More SQL Server Cons →

"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement.""Apart from Control-M, it would be nice if it could integrate with other tools.""Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good.""Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives.""Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve.""The scalability could be better. The on-premises solution is always more complicated to scale.""Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency.""It could use some more advanced analytics relating to structured and semi-structured data."

More Teradata Cons →

Pricing and Cost Advice
  • "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."
  • "The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions."
  • "It's cheaper than Oracle."
  • More SQL Server Pricing and Cost Advice →

  • "The solution requires a license."
  • "The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."
  • "The price of the solution could be reduced, it is expensive."
  • "Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
  • "The cost of running Teradata is quite high, but you get a good return on investment."
  • "Teradata pricing is fine, and it's competitive with all the legacy models. On a scale of one to five, with one being the worst and five being the best, I'm giving Teradata a three, because it can be a little expensive, when compared to other solutions."
  • "The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
  • "The price of Teradata could be less expensive."
  • More Teradata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    635,513 professionals have used our research since 2012.
    Questions from the Community
    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.
    Top Answer:Any value this product provides is offset by the high cost and lack of scalability. We're moving to Snowflake because of the scalability and cost differentials. There are better, more flexible… more »
    Top Answer:Our use case is for data warehousing and BI reporting. We are customers of Teradata.
    Ranking
    Views
    23,347
    Comparisons
    17,659
    Reviews
    164
    Average Words per Review
    444
    Rating
    8.2
    Views
    13,007
    Comparisons
    10,508
    Reviews
    14
    Average Words per Review
    481
    Rating
    8.2
    Comparisons
    Also Known As
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    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.

    Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

    Offer
    Learn more about SQL Server
    Learn more about Teradata
    Sample Customers
    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.
    Netflix
    Top Industries
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Computer Software Company18%
    Comms Service Provider16%
    Financial Services Firm10%
    Government6%
    REVIEWERS
    Comms Service Provider27%
    Computer Software Company20%
    Financial Services Firm13%
    Energy/Utilities Company13%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company18%
    Comms Service Provider11%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business42%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise14%
    Large Enterprise66%
    REVIEWERS
    Small Business35%
    Midsize Enterprise10%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise10%
    Large Enterprise77%
    Buyer's Guide
    SQL Server vs. Teradata
    September 2022
    Find out what your peers are saying about SQL Server vs. Teradata and other solutions. Updated: September 2022.
    635,513 professionals have used our research since 2012.

    SQL Server is ranked 1st in Relational Databases Tools with 165 reviews while Teradata is ranked 5th in Relational Databases Tools with 16 reviews. SQL Server is rated 8.2, while Teradata is rated 8.2. The top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". SQL Server is most compared with Oracle Database, SAP HANA, LocalDB, MariaDB and IBM Informix, whereas Teradata is most compared with Snowflake, Oracle Exadata, Vertica, Microsoft Azure Synapse Analytics and MySQL. See our SQL Server vs. Teradata 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.