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 installation is really easy."
"The solution is very easy to use. It's intuitive and easy to navigate. Overall, it's a straightforward product."
"We are using the net for our environment. We're using the ADF Azure data factory for our analysis services, and it is pretty good."
"Very stable relational database management system that offers ease of management, querying, and scaling. It has well-designed databases."
"It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs."
"It is integrated with Microsoft tools."
"The most valuable features of this solution are easy queries and straightforward programming for beginners."
"The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"It's very mature from a technology perspective."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"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 functionality of the solution is excellent."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"It is a stable program."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."
"We experience latency at times when there is a lot of data being processed."
"The GUI needs improvement. From a technical perspective, it's quite complex, which may not be a problem for individuals with technical backgrounds like ours, especially since we've encountered similar interfaces. However, navigating the GUI can be challenging for newcomers or product owners without technical experience. For example, as someone transitioning from a developer role to a product management role, I find it relatively easy to use the GUI. But for those without a technical background, it's much more challenging to grasp what's happening."
"Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems."
"For small-scale businesses, Microsoft could improve by removing some limits in SQL Express."
"SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance."
"It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it."
"It could use some more advanced analytics relating to structured and semi-structured data."
"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."
"The increasing volumes of data demand more and more performance."
"Limited interest and success in some areas make us hesitate about upgrading."
"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 is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"It would help to make scaling easier with a reduced cost. "
"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 Amazon Redshift. 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.