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.
"The performance of SQL Server is perfect."
"It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based. It is a very stable product, and it has got backup and recovery tools."
"The technical support that Microsoft provides is great."
"The solution is easy to use."
"Very good security features."
"It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that."
"SQL Server, a widely adopted database management system, is utilized across numerous sectors. Initially competing with Oracle and Db2, SQL Server has gained popularity. It serves as the backend database for a variety of applications."
"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."
"The initial setup was straightforward."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"Designing the database is easy."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"The flexibility in design is very good."
"It's very, very fast"
"I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server."
"I would like to see better integration between their link server and other platforms, such as IBM."
"It would be ideal if the solution offered better integration capabilities."
"CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server."
"We need it to support Linux for better troubleshooting flexibility."
"Maintenance of the solution is an area of concern, and improvements can be helpful."
"When transferring data from the SQL Server to Excel, the data types are not copied correctly. This issue might be associated with the formatting of the data types."
"There are a few use cases where we do need the Active-Active options instead of Active-Passive, yet those kinds of options are not available for Microsoft."
"Teradata hardly supports unstructured data or semi-structured data"
"The setup is not straightforward."
"The SQL Assistant is very basic. This tool can be improved for usability."
"It would help to make scaling easier with a reduced cost. "
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"Teradata can improve the way it handles big data and unstructured data."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"The following could be better: licensing, architecture openness, integration with other tools."
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.