We performed a comparison between Oracle 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: Of the two solutions, a lot of users favor Oracle. However, users are happier with the price of SQL Server.
"The solution is very stable."
"Scalability, reliability, and performance are what we are getting with this solution. It is highly scalable and has very good performance. It also has in-built monitoring and optimized optimizer. It is quite stable and secure. When it comes to integration, you can integrate it with other tools as well. However, we have been using Oracle Database within our own premises. So, it is kind of difficult for us to basically do a kind of integration with the outside software. We prefer to do things within our own premises."
"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."
"Significant assistance in tuning both the migration process and the production database was provided by Oracle Consulting Services, which provided excellent and very professional advice."
"The solution is easy to use. It also offers a Database Vault."
"The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful."
"The tool is efficient and fast compared to other alternatives. The tool's processing speed is fast, and we've experienced minimal hang-ups. This enables us to address queries within a shorter time frame. I wouldn't say it's just one particular feature, but overall, the efficiency and speed of Oracle Database have had a significant impact. Our support systems are more efficient, allowing us to accomplish tasks quickly."
"The ease of migration between databases."
"The technical support that Microsoft provides is great."
"The pricing of the product is very good."
"SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"The solution is very easy to use."
"The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application."
"The product has been on the market for over 25 or 30 years. It's an extremely mature solution."
"The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities."
"The initial setup is a bit complex."
"The integration can be made much easier for the Oracle tools, for example, Oracle Database or OPI. The integration sometimes can be a little complicated for us because we have to do a number of integrations with other tools, such as Oracle computation. The integration could be more streamlined and easier to work with."
"Probably about 80% of their online documentation is useless. When you go to the Oracle documentation, you have to plow through page after page of stuff to get to anything that looks anything like an example of what it is that you might actually do. There are lots of other people who have filled that gap, and there are also websites where you can easily find the answers to most of your questions."
"The integration with other vendor solutions needs improvement. It is difficult to connect to other hardware."
"The solution could improve security."
"Better integration with other databases would be an improvement."
"Its price can be improved."
"The tool's price gap is a major concern. It makes it hard for others to afford it and use it effectively. More people could benefit from its features if the pricing could be made more reasonable. Many companies choose cheaper options because of this affordability issue."
"I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."
"There are certain shortcomings in the scalability of the product, making it an area where improvements are required."
"I would like to see more integration with other products and it needs to be more secure."
"In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages."
"From a development perspective, the solution needs to be a lot easier to understand or it needs to be easier to implement API packages for connection pooling so we don't have connection interruptions when, let's say, a hundred people simultaneously access the network on a given system, utilizing a specific or single database."
"When we run into problems, it's usually during installation, and finding answers to the problem has been a nightmare because the documentation is terrible."
"I would appreciate a dark theme for SQL Server Management Studio and ability to add databases with TDE enabled into availability groups."
"You do need to have technical knowledge in order to install the solution. It's not something a layperson can do."
Oracle Database is ranked 2nd in Relational Databases Tools with 283 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Oracle Database is rated 8.6, while SQL Server is rated 8.4. The top reviewer of Oracle Database writes "Supports a large volume of transactions compared to other databases". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Oracle Database is most compared with SAP HANA, MariaDB, IBM Db2 Database, Amazon Aurora and MySQL, whereas SQL Server is most compared with MariaDB, SAP HANA, LocalDB, IBM Db2 Database and Teradata. See our Oracle 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.
As always, it depends: First look is the area: on-premise server (your own hardware) or in the cloud?
If you want to use your own server, look at the operating system? In my opinion, SQL Server fits best on Windows; Oracle on Unix/Linux. Next is your size of data and the application you want to use: rule of thumb: the more data, the more I tend to Oracle; but Oracle is not 'automatically better'! You need an expert to configure the system for optimal use! A simple setup is often not enough! (There are a lot of screws you can turn, but turning the wrong ones is a negative! And more Hardware is not the solution to a slow system). I think the first step is to look at which app creates and consume which data, where in your network is your data needed and then decide the RDBMS. I have worked for years in a mixed environment; we use a large Oracle RDBMS on AIX to store the large amount of data of several production systems; but also some SQL Server RDBMS to distribute data for some evaluations or reports. In the Oracle RDBMS are 30 Years of data of the whole production process; in SQL Servers are consolidated data for reporting. So first make a compilation of your existing data and application and the future requirements; then you can decide; and the result can also be a mixed world!