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

Oracle Multitenant vs SQL Server comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Oracle Multitenant
Ranking in Relational Databases Tools
13th
Average Rating
8.6
Number of Reviews
19
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
267
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the Relational Databases Tools category, the mindshare of Oracle Multitenant is 0.6%, down from 0.6% compared to the previous year. The mindshare of SQL Server is 20.1%, down from 23.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

François Dernoncourt - PeerSpot reviewer
Databases are automatically upgraded and cloning of pluggable databases requires just one command
Multitenant has a container database with many pluggable databases. A great feature is that you can upgrade the container to a more recent version and all the pluggable databases are automatically upgraded to that version. Previously it would have required an upgrade for each database. The second great feature is the clone which enables you to get the clone of pluggable databases with one command, as opposed to copying data from one place to another.
Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

Quotes from Members

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

Pros

"The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine."
"Multitenant has a container database with many pluggable databases."
"Maintaining databases is a valuable feature for us."
"You can scale the solution as needed."
"I would rate the scalability a ten out of ten. Our clients are mostly medium and enterprise businesses."
"The feature that I like on Multitenant is the ease - it is very easy for my team to run the database."
"The most valuable features are the speed and ease of use."
"Our primary use of Oracle includes writing queries for retrieving data for customers without worrying about the customer ID, user ID, as it is automatically connected to each query."
"Tuning Advisor suggests where to add indexes and from where to remove them. It works like an adviser."
"Similar to Microsoft SQL, it is easy to scale."
"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."
"SQL is stable."
"I use the menu on the management view credit section to get information from the database."
"The most valuable features of this solution are easy queries and straightforward programming for beginners."
"There is a lot of information about the solution readily available online."
"SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties."
 

Cons

"It can be complicated to scale up the solution, but it's scalable."
"The user interface for this solution can be made better."
"While the product is overall excellent, it is quite expensive."
"That said, Oracle in general doesn't invest in their UI for any of their applications. If we're talking about the dashboard or other user experience, there is room for improvement. I'm talking about on premises. The cloud version has started to improve."
"There is room for improvement in customer service and support."
"Technical support could be faster."
"There are many functions where changes are not easy to implement, and we try to avoid modifying these areas due to security issues and the complexity of maintaining them."
"The solution lacks a GUI for commands."
"The installation process should be simplified."
"Scalability is an area that needs improvement, and the deployment is difficult, which why I'm looking for an appliance to deploy it in a much more scalable way."
"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."
"We pay a license fee, it could always be cheaper."
"Sometimes we experience issues with its stability."
"Right now we don't get much technical support from Microsoft"
"SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."
"Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions."
 

Pricing and Cost Advice

"This solution is a little bit pricey."
"The price is worth the quality."
"For me, I will go with it if I have the budget. Some features are nicer than before, but at the end of the day, you always have a limited budget. I prefer to upgrade and get a specific hardware when possible. At the end, you will have to make a compromise. You will not get everything you would have liked to have."
"SQL Server is expensive if you use the advanced SQL version, but if you use the standard version, it's not expensive."
"Our customers do pay license fees for the MS SQL Server but the Rabbit is free, as it is open-source software."
"There is a license required for this solution."
"Although it comes with a cost, using the most recent version is highly advisable, since it would ensure a certain measure of bug fixes and stability. The sole issue would involve the cost, as this is expensive."
"Depending upon your usage, you can use the pay-as-you-go model for a short period of time. For longer projects, we can opt for one-year or a three-year license."
"The licensing involves a one time fee."
"Pricing is a bit on the higher side."
"For a brief period, approximately one year before 2018, I had experience working with the open-source version of SQL Server. During that time, I found SQL Server to be the preferred choice, in my opinion."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
837,501 professionals have used our research since 2012.
 

Answers from the Community

Akın Kurtulan - PeerSpot reviewer
Jun 9, 2022
Jun 9, 2022
Hi Akin, First, both DBs manage your relational data on several operating systems (Linux, Windows Server, ...) and as Cloud Services. The newer architecture of Oracle tries to support you in a mixed environment where you can distribute a large DB over your own servers and cloud services. But as we always saw in the past, if a new feature of Oracle is good, Microsoft will follow. So your main qu...
2 out of 3 answers
PG
Jun 7, 2022
Hi Akin, First, both DBs manage your relational data on several operating systems (Linux, Windows Server, ...) and as Cloud Services. The newer architecture of Oracle tries to support you in a mixed environment where you can distribute a large DB over your own servers and cloud services. But as we always saw in the past, if a new feature of Oracle is good, Microsoft will follow. So your main questions should be: -How big is your DB? The bigger, the more I suggest Oracle. -Are you in a mixed world (Cloud and your own servers)? If Cloud is Azure, I think SQL Server is a good choice. -Is the price a topic? The liscence rules of Oracle are sometimes complicated. Hope this helps a little.  
Martin Zwarthoed - PeerSpot reviewer
Jun 8, 2022
Hi Akin, Without going into the technical details; did you have a look a the pricing of MSSQL and Oracle databases?  I always hear that the Oracle database is better than MS SQL. But I never got to test this myself. What I do know is that when I tell a customer the Oracle pricing, they are usually going in another direction.  You must have a very good functional reason to go for Oracle considering the price difference. As @Patric Gehl ​suggested: a very big database is good but for a good reason. Kind regards, Martin Zwarthoed
 

Top Industries

By visitors reading reviews
Financial Services Firm
22%
Computer Software Company
9%
Hospitality Company
7%
Manufacturing Company
7%
Educational Organization
52%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Multitenant?
The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine.
What is your experience regarding pricing and costs for Oracle Multitenant?
I am not connected to the financial aspects, so I am unable to provide details.
What needs improvement with Oracle Multitenant?
There are many functions where changes are not easy to implement, and we try to avoid modifying these areas due to security issues and the complexity of maintaining them. Also, support can be impro...
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

Oracle Pluggable Database
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

An Post, National Oilwell Varco, SAS Institute, Sportmaster, Y-Telecom
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 Multitenant vs. SQL Server and other solutions. Updated: January 2025.
837,501 professionals have used our research since 2012.