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 interface for building the queries or writing the store procedures is good."
"The performance is good."
"Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms."
"I would say that it is a stable product."
"SSAS is the most interesting feature to organize the data and let the users play with it."
"We like business integration, database, and analysis."
"Its usability is very good. Its performance is satisfactory."
"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."
"The solution scales well on the cloud."
"It's very mature from a technology perspective."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"The flexibility in design is very good."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"Its ability to handle certain kinds of large data could be improved."
"The pricing could be more affordable."
"While this is a reliable product, it has room for improvement."
"The installation process should be simplified."
"They could improve the solution by allowing more portability between on-premise and the cloud."
"The solution could improve by having more integration with other operating systems and other platforms."
"Sometimes the system hangs. Its databases should be able to deal with more data in a faster way. Its speed of processing larger amounts of information should be improved."
"The ability to connect with other environments needs to be improved."
"The setup is not straightforward."
"Data synchronization to the DR site."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"The SQL Assistant is very basic. This tool can be improved for usability."
"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."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"I'm not sure about the unstructured data management capabilities. It could be improved."
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.