IBM Db2 Database Competitors and Alternatives
Read reviews of IBM Db2 Database competitors and alternatives
User at a manufacturing company with 10,001+ employees
A stable, scalable, and easy-to-deploy solution that pretty much covers everything
What is our primary use case?The .NET applications use SQL Servers on a very large scale. Basically, about 80% or 90% of the database platform is on SQL Server. We are working on version 2019, but we are also now working on the cloud databases. Our goal is to stay away from versions. We are going to go version-less and move to Azure SQL or managed instance, which is version-less. This way we won't need to worry about any upgrades or any version changes because Microsoft is going to take care of these things. We will always have the latest and greatest version.
Pros and Cons
- "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."
- "There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product."
What other advice do I have?You need to know the concepts and the business logic before using this solution. It is not straightforward. You need to know what your application needs are and only then you can work on it. You also need to know about the product and how it works. I would probably advise others to move to the cloud version, which is a modern database. If you want to use SQL Server, Azure is the best because you get the hybrid benefits. You can bring your own license, and you can save costs. You can save 55% of the cost. With AWS, you have to buy your license, which makes it expensive. If you are using SQL…
Infrastructure Manager at Lactanet
Jun 25, 2020
Reliable and robust with good support
What is our primary use case?We work in agriculture, and where we're located we have two sites in two separate cities in Canada. These are all transactional databases and they have information in them about the dairy industry in our country. We use it for storing data related to dairy cows, dairy farmers, or farmers in general, and we have all the information in the transactional database that holds everything from billing to individual animal data. We probably have about 12 terabytes of data on the Oracle databases.
Pros and Cons
- "The reliability is the solution's most valuable feature. We've had great success with the solution."
- "The main thing we find could use improvement is the licensing costs. It is quite expensive relative to other database vendors. Cost always comes up as an issue for us as we consider upgrade paths. It's not as easy as we would like it to be."
What other advice do I have?We started using version 7 of Oracle, and now, after so many years on the product, we are up to version 12. We have six different main production databases that we use for various things. They're all on-premise. They either run in a Linux environment or IBM AIX Unix environment. And we also use a backup Oracle cloud for backing up some of those databases. The main advice I would give other organizations would be to prepare for the costs. Oracle is kind of more expensive than in most other database software. It's also important to have a good understanding of how Oracle works and the…
Data Engineer at a retailer with 10,001+ employees
Real UserTop 5
Jun 30, 2020
A great open-source product that offers great scalability and compatibility
Pros and Cons
- "MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."
- "They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."