We performed a comparison between IBM Db2 Database and SQL Server based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: IBM Db2 Database has an edge in this comparison due to the high marks it received for its performance. Reviewers are happier with the pricing of SQL Server, however.
"It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue."
"Scalability-wise, I rate the solution a nine out of ten."
"The most valuable feature of the IBM Db2 Database is security."
"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."
"Its robustness, scalability, availability, and performance are valuable. All these are the major attributes of a relational database for supporting a very high-volume business, and Db2 is very good in all those areas and in all those attributes."
"The solution is stable."
"The solution helps secure the database."
"I have found the most valuable feature to be its availability."
"It will do clustering, so you can have two database servers looking at the same data simultaneously."
"SQL Server scales well."
"The most valuable features of this solution are easy queries and straightforward programming for beginners."
"I like that it's a cloud solution, is simple to set up, and is simple to use."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well."
"Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as collation for the data warehouse, Cube-generation, and ad-hoc processes. The ease in which you may mold a process flow or even modularly add in new structures is something which is much needed in my job."
"The SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward."
"The queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners."
"Some of the internal rearrangement in the administration is not as straightforward as it is in competing products."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"Their view of it is they're maintaining it, they're continuing to upgrade it, they're continuing to grow it, however, they don't go out and try and sell that as an architectural solution the way they do Linux and Unix."
"The backup solution lacks flexibility."
"I would like to see better support for advanced analytics."
"The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down."
"IBM Db2 Database could improve the user-defined functions. There are some user-defined functions that are missing, such as the spring functions. I used to have Teradata for my projects and I was used to working in the environment. They had a good set of user-defined functions."
"SQL Server could improve by having better usability or user guidance."
"Improvement in SQL Server should focus on lowering the high cost, especially for environments requiring extensive CPU and memory usage like data warehousing"
"Third-party services from Redgate should be built-in to it, like SQL Search."
"Something that could be improved is the cost because it's very high. That's the only thing I'm concerned about but the technology is good."
"They could improve by adding the SQL format."
"It's difficult to make changes. It's a very complicated product in general — that's the issue."
"The interface integration could be better."
"It would be nice if there was a feature to search for a specific value across multiple tables. This would save a lot of time for its users."
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. IBM Db2 Database is rated 8.2, while SQL Server is rated 8.4. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". IBM Db2 Database is most compared with Oracle Database, SAP HANA, Teradata, MySQL and Oracle Database In-Memory, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and Teradata. See our IBM Db2 Database vs. SQL Server 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.