Try our new research platform with insights from 80,000+ expert users

Oracle Java DB vs SQL Server comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Oracle Java DB
Ranking in Relational Databases Tools
27th
Average Rating
8.2
Number of Reviews
8
Ranking in other categories
No ranking in other categories
SQL Server
Ranking in Relational Databases Tools
1st
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
266
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Relational Databases Tools category, the mindshare of Oracle Java DB is 0.6%, down from 0.8% compared to the previous year. The mindshare of SQL Server is 22.0%, down from 23.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Anil-Sinha - PeerSpot reviewer
Able to process all the reporting and processing in the database itself
We have been upgrading and moving to new environments. I was involved in the solution's initial setup. Some things in the setup are very smooth sailing. However, some setups become complicated because what they set up doesn't meet your needs. So, some tweaking is necessary in certain instances. Having a good understanding of the tool really helps. Oracle Java DB is easy to deploy if it's a new setup. Migrating from an old environment to a new environment takes time because you need the old functionality. A first-time deployment of the application is easy. We just did a default setup and started using it. When we have to migrate, there is too much baggage behind that application, especially from the security point of view.
AhmadTalha - PeerSpot reviewer
A robust and secure solution that helps to store data
The GUI needs improvement. From a technical perspective, it's quite complex, which may not be a problem for individuals with technical backgrounds like ours, especially since we've encountered similar interfaces. However, navigating the GUI can be challenging for newcomers or product owners without technical experience. For example, as someone transitioning from a developer role to a product management role, I find it relatively easy to use the GUI. But for those without a technical background, it's much more challenging to grasp what's happening.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Able to write queries more efficiently and the management of data has become better and easier."
"It's very clever."
"The solution is stable."
"There have been no issues in relation to stability. We've never really had do to any recoveries. It is very stable."
"The most valuable feature is automation."
"It has a programming language so anything that we require for Selenium is all available there."
"The database is quite robust in terms of performance from the SQL side."
"The additional value of having Java inside the Oracle database is all the security that is applied to an Oracle database will be enforced on Java's stored procedures as well."
"The solution's most valuable part revolves around data management, which can be seen in its audit features and performance."
"The initial setup was straightforward."
"SQL Server is a very mature solution."
"One of the best features of SQL Server is the efficient retrieval of information."
"It is easy to deploy and easy to maintain."
"The product is easy to use."
"The installation is pretty straightforward."
"Agent service is a good feature of SQL Server, where you can schedule certain tasks."
 

Cons

"The tool might be integrated, but we see performance issues because of overhead."
"Needs improvement in consistency issues with respect to timeframes."
"In terms of improvement, I'd like an automation tool that is lower priced. The core prices are very high."
"The solution could be more user-friendly."
"The solution should continue to keep updating and improving the Java language."
"The biggest lesson that I have learned from using Oracle products is vendor lock-in."
"It'll be better if Oracle Java supports open source technologies, like Node.js."
"We would like to have a common storage option in the SQL Server. This option is available in Oracle Database. It would be great if Microsoft could create something like a columnstore that has not only indexing but also tables for common storage."
"They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive."
"We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud."
"The solution is lacking a compound index for comparing values."
"The performance needs some improvement and it needs more features integrated into it."
"Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions."
"The scalability could be better."
"It would be great if we were able to run it on multiple operating systems and not only stick with Windows."
 

Pricing and Cost Advice

"The product's pricing is very friendly, with no extra costs after the licensing fees."
"Oracle Java DB is a pricey solution."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing a seven out of ten."
"For smaller companies, they find this solution expensive."
"There is a subscription that needs to be purchased to use the solution."
"Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license."
"This is a downside of enterprise Microsoft products."
"The price of SQL Server could be better in the African market. The licensing model needs to be improved, it is confusing."
"It requires the purchase of a license."
"It costs a lot."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Computer Software Company
13%
Educational Organization
11%
Manufacturing Company
7%
Educational Organization
49%
Financial Services Firm
9%
Computer Software Company
7%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What needs improvement with Oracle Java DB?
The tool might be integrated, but we see performance issues because of overhead.
What is your primary use case for Oracle Java DB?
We are using the Java side, which is built into the database, and the application is using that portion.
What advice do you have for others considering Oracle Java DB?
I think the solution is moving in the right direction because no architecture supports all sorts of processing. A lot of other portions are getting integrated as new needs come in. With integration...
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

No data available
Microsoft SQL Server, MSSQL, MS SQL
 

Learn More

 

Overview

 

Sample Customers

Université Nice Sophia Antipolis
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about Oracle Java DB vs. SQL Server and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.