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.
"SQL Server is a very mature solution."
"I like that it's a cloud solution, is simple to set up, and is simple to use."
"It helps with moving the design of the database into reality."
"One of the things I most like about SQL Server is the log shipping piece. This is a great feature."
"I use the menu on the management view credit section to get information from the database."
"SSAS is the most interesting feature to organize the data and let the users play with it."
"What I like most is the management, as it is very easy compared with other products."
"I have contacted technical support, and overall my experience with technical support was okay."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"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."
"Designing the database is easy."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"Cuts time to process huge amounts of data with efficient analytical queries."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"The Task Scheduler has a lot of shortcomings. This could be improved quite a bit."
"When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"The solution could use better governance on the management side, especially around data governance."
"You do need to have technical knowledge in order to install the solution. It's not something a layperson can do."
"The agility of the non-SQL-based features is relevant on the market."
"Additional interfaces would be an improvement."
"More things in SQL Server need to be automated."
"I would like to see more integration with many different types of data."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"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."
"Teradata can improve the way it handles big data and unstructured data."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
SQL Server is ranked 1st in Relational Databases Tools with 22 reviews while Teradata is ranked 7th in Relational Databases Tools with 21 reviews. SQL Server is rated 8.4, while Teradata is rated 8.4. The top reviewer of SQL Server writes "Stores all of our data, and there is nothing that it can't do". 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 MariaDB, SAP HANA, Oracle Database, IBM Db2 Database and Amazon Aurora, whereas Teradata is most compared with Snowflake, MySQL, Oracle Exadata, 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.