We performed a comparison between SQL Server and Teradata based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Because Teradata is more expensive, has harder initial setup, harder scalability, and fewer features, SQL Server ultimately wins out in this comparison.
"It is one of the most stable relational databases out there."
"The security and vulnerability management are well-managed through the vendor."
"The solution is configurable."
"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."
"Features like autoscaling, business continuity, and security are beneficial. The tool's compatibility with almost all of the enterprise-class applications is also beneficial for users."
"The solution is easy to use."
"It helps with moving the design of the database into reality."
"The stability is fine, especially if you're hosting it on AWS or Azure. You can get up to 99.99% stability on AWS."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"Teradata's most valuable feature is that it's easy to use."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"It's very, very fast"
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"Designing the database is easy."
"The performance is great, we are able to query our data in one operation."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"The price could be better. In the next release, it would be better if the database was more easily extendable."
"I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."
"The ability to connect with other environments needs to be improved."
"The solution's stability can be improved."
"I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins."
"Price could be cheaper, and access to reporting tools should be better."
"Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers."
"The solution could be more secure."
"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."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"GUI of administrative tools is really outdated."
"Limited interest and success in some areas make us hesitate about upgrading."
"Data synchronization to the DR site."
"I would like to see an improved Knowledge Base on the web."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
SQL Server is ranked 1st in Relational Databases Tools with 260 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. SQL Server is rated 8.4, while Teradata is rated 8.2. The top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and Amazon Aurora, whereas Teradata is most compared with Snowflake, Oracle Exadata, MySQL, BigQuery and IBM Db2 Database. 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.