We performed a comparison between IBM Db2 Database, Oracle Database, and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."The most valuable aspect of this solution is its stability. We have never had any problems and have never had to contact technical support."
"The solution has many beneficial features, such as security, support, and stability."
"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."
"It's the best solution in terms of security, performance, and availability because the system is available 24/7."
"The setup process has become much easier recently."
"We are dealing with millions of transactions a month and the performance is very good."
"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."
"it is very stable and runs smoothly once it is deployed and it is almost maintenance-free."
"It is user-friendly. It didn't take me much time to learn it."
"The ease of use has been great."
"It has good features for performance tuning."
"As a database, the solution has been number one from the beginning."
"The solution is scalable."
"The technical support is good, we have responses to our problems."
"Most of our customers have been using multitenant options. Advanced Compression and Advanced Security are the most valuable features in most customer environments."
"I am not an IT person. I am an end-user of this solution, and based on my experience, it is comfortable to work with. Everything is okay, and the data is timely available. It can also be easily integrated."
"I have contacted technical support, and overall my experience with technical support was okay."
"You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations."
"The initial setup was straightforward."
"SQL is stable."
"The solution is easy to use and provides similar features to other competitors."
"The solution is easy to use."
"It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching."
"Easy to implement and user-friendly relational database management system. This product is stable and scalable."
"Db2 interface could be improved a bit. Comparing it to Oracle, Db2's interfaces could be improved."
"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."
"It would be helpful to have a hybrid data storage facility that includes NoSQL technologies."
"Do not use support. Freely available documentation is a bit weak."
"We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."
"There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved."
"I would say that the tool has to be made more cloud-friendly and should have agreements with AWS, Microsoft, or Google to run things on hyperscalers."
"The product’s user interface is not easy to use."
"The quality of technical support could be better. They could respond faster."
"The product could be cheaper."
"There are good dashboards and other features, but it was previously included in licensing. They are now charging for each and every feature. It was previously bundled."
"Support is not available when one encounters problems."
"When it comes to Oracle, the only complaint that I have is their support. For business-critical cases, finding support is a little bit difficult because of the timezone difference. They should provide faster support to resolve issues on time."
"The cost needs to be reduced because right now, all of our customers are asking us about how they can migrate to any open-source database."
"Customer support could be faster, you currently have to write your issue to them and then they will get back to you after 24-hours."
"Problems can arise if there are too many requirements or a lot of details which must be applied to connect the software to the database."
"In my experience, I've found that scalability can be improved."
"The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient."
"Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits."
"As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes."
"It needs to be improved to handle big data for large volumes of transactions for big industries. As compared to Oracle Database, SQL Server is not suitable for big data or large organizations where the database size could be more than 100 GB or more. In our country, for a large database and a large volume of transactions, we normally use Oracle Database. Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."
"I would like to see more integration with other products and it needs to be more secure."
"Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved."
"As SQL server could not support the number of connections we desired, we were forced to go with Oracle."