We performed a comparison between IBM Db2 Database, SQL Server, and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."I have found the most valuable feature to be its availability."
"The solution can scale."
"Db2 Database has given us good results since we have started to use it. We predominantly use IBM hardware, and this is one of the reasons why we started to use Db2 Database. Db2 Database has a very good HADR capability. High availability resilience is also good in this solution. It also has pureScale, which allows you to upgrade one node to get very good and high-level resilience. If you are using a database on five nodes, you can take one node down, upgrade that, and let that node up. You can then bring the second node down, upgrade that, and so on."
"When you submit a ticket the response time is quick."
"The solution helps secure the database."
"it is very stable and runs smoothly once it is deployed and it is almost maintenance-free."
"Very good for performance and scalability."
"The scalability and availability of this solution are the most valuable features."
"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 backup capabilities are extremely good."
"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 initial setup is time-efficient and can be done independently."
"The license fee is very low."
"We've found it to basically be pretty problem-free."
"SQL Server stands out due to its robust parallel processing capabilities."
"It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage."
"Auto-partitioning and indexing, and resource allocation on the fly are key features."
"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."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"The most valuable feature of Teradata is the quick processing of large data."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"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."
"It's very mature from a technology perspective."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"The technical support team is not very good when compared to the efficiency of Oracle's support."
"Do not use support. Freely available documentation is a bit weak."
"Its process of building up queries could be more accessible."
"It would be ideal if the solution offered backup functionality. Many similar tools already do, which means Db2 is somewhat behind the curve in terms of what a customer might expect from it."
"Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced. The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition. In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem."
"The initial set up was complex."
"The solution could improve by providing more integration."
"The solution could be better when it comes to security."
"The solution is expensive. The licensing costs are high."
"The performance needs some improvement and it needs more features integrated into it."
"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."
"I am fine with the pricing, but pricing is an area that can always be improved."
"We need it to support Linux for better troubleshooting flexibility."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"SQL Server could be improved with cheaper licensing because it's very expensive."
"Limited interest and success in some areas make us hesitate about upgrading."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"The following could be better: licensing, architecture openness, integration with other tools."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"I would like to see an improved Knowledge Base on the web."
"Teradata hardly supports unstructured data or semi-structured data"
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"Teradata can improve the way it handles big data and unstructured data."