We changed our name from IT Central Station: Here's why

Oracle Database vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
Oracle Database Logo
15,552 views|9,184 comparisons
SQL Server Logo
19,554 views|14,983 comparisons
Featured Review
Find out what your peers are saying about Oracle Database vs. SQL Server and other solutions. Updated: January 2022.
565,689 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"When we are not able to solve a problem we immediately contacted Oracle support team to help us solve it.""From a database product perspective, I would say, they're good in what they provide. There's not much concern.""It's very reliable.""It's powerful and fast, and the backup system is wonderful.""The performance of the solution is impeccable.""I've never faced any stability issues with the product. I don't recall any bugs, glitches, or crashes. I'd say it's fairly stable and shouldn't cause anyone issues in that regard.""The ease of migration between databases.""I like the enterprise features as well as the stability."

More Oracle Database Pros →

"The initial setup was straightforward.""From a security perspective, we have no complaints.""It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups.""The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL profiler and SQLCMD as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly.""The initial setup isn't overly complex.""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.""We've found it to basically be pretty problem-free.""The solution has proven to be very stable."

More SQL Server Pros →

Cons
"Once you start with Oracle you become locked into it.""I would also like to see more features added and the stability needs improvement.""The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model.""An area for improvement would be query performance - in some cases, it's really, really hard to make it run faster.""It should have more monitoring features. There should be features to be able to analyze the performance with a query. In Microsoft SQL Server, when you are running any stored procedure, if you want to analyze the performance, you just run the query analyzer. You can easily find out that something is missing in a joint condition, or clustering needs to be added because of a delay. I can't find such features in Oracle Database. They should be added.""They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality.""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 product is pricey and expensive."

More Oracle Database Cons →

"In some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated.""I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability.""It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting.""You do need to have technical knowledge in order to install the solution. It's not something a layperson can do.""It could be more stable.""SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance.""They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers.""The configuration process can be a little complex."

More SQL Server Cons →

Pricing and Cost Advice
  • "Our licensing costs are between $40,000 and $50,000 per year. Those are the costs that cover maintenance and licensing."
  • "The pricing is something that Oracle should work on to make the product more affordable, especially to businesses in third-world countries."
  • "It is very expensive. We pay in dollars, so the inflation and conversion cost is also there for us. They charge on a yearly basis for the license."
  • "Its price is already low. Oracle has a competitive and cheaper price as compared to others. Oracle Cloud is cheaper than other clouds. The pricing is very competitive for Oracle Cloud to be in the market. Their pricing makes customers interested in using this product even though Oracle doesn't have a local data center at this moment."
  • "They are pricing themselves out of the market."
  • "It is expensive."
  • "It's expensive. I would say that it is more expensive than other competing products."
  • "It's not cheap, but sometimes, you get what you pay for."
  • More Oracle Database Pricing and Cost Advice →

  • "SQL Server is a cost-effective solution for a small database."
  • "Pricing is reasonable for small organizations, but the scaling increases the price."
  • "We didn't have any licensing costs for SQL Server."
  • "We pay approximately $12,000 USD per month for both the server and the license."
  • "The price could be cheaper."
  • "Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    565,689 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    DB2 versus Oracle: - Table structure is different - Data structures - there are some differences including the data type, format and length.
    Top Answer: 
    The most valuable feature of Oracle Database is its stability - one can trust that the database is always working.
    Top Answer: 
    The price of Oracle Database is too expensive and especially for individual environments. The pricing model is not clear, if I want to run it on a virtual environment, I still need to license the… more »
    Top Answer: 
    I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.
    Top Answer: 
    Licensing fees increase depending on size and performance. If you want higher performance, you should go for a different course.
    Top Answer: 
    The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions.
    Ranking
    2nd
    Views
    15,552
    Comparisons
    9,184
    Reviews
    109
    Average Words per Review
    417
    Rating
    8.5
    1st
    Views
    19,554
    Comparisons
    14,983
    Reviews
    135
    Average Words per Review
    462
    Rating
    8.2
    Comparisons
    Also Known As
    Oracle 12c, RDBMS
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities for breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in two editions to fit your business needs and budget: Enterprise Edition and Standard Edition 2.

    For more information on Oracle RDBMS, visit Oracle.com

    SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

    Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

    Offer
    Learn more about Oracle Database
    Learn more about SQL Server
    Sample Customers
    Agncia Nacional de guas, Anbima, Aria Systems, Asiana Airlines, Astelit LLC, Australian Finance Group, Banco Occidental de Descuento, Bharat Petroleum Corporation Limited, BT, Caja de Seguros S.A., Casas GEO S.A.B. de C.V., Comic Relief UK, Corsair Components Inc., CSAM Health AS, CSOB Group, Datacraft Solutions, DenizBank A.S., Department of Treasury and Finance WA, Office of State Revenue, Deutsche B_rse AG, Deutsche Lufthansa AG, Deutsche Messe AG, Digicel Haiti, DPR COSEA, Essar Group, Essatto Software Pty Ltd, Farmšcia e Drogaria Nissei Ltda., Fomento Econ‹mico Mexicano S.A.B. de C.V. (FEMSA), FundaÊo Petrobras de Seguridade Social, Future Group, GFKL Financial Services AG, Grupo Posadas S.A.B. de C.V., Grupo Sinosserra, Guerra S.A. Implementos Rodovišrios, Hanatour International Service, Hays plc, Henan Mobile Co. Ltd, Hochschule Hof, Hong Kong and China Technology (Wuhan) Co. Ltd (Towngas Technology), Industries Corpa_al C.A., Infrastructure Development Finance Company Limited, Instituto Brasileiro de Geografia e Estatstica, Instituto Mexicano de la Propiedad Industrial, Kcell, LinkShare Corporation, MercadoLibre Inc., MetLife Inc., Nextgen Distribution, €BB-IKT GmbH, Octagon Research Solutions, Pacific Lutheran University, Paragon Data GmbH, Ping ltd., PJSC Trustbank, Prodaub _ Processamento de Dados de Uberl_ndia, Purdue University, Redknee Inc., Robi Axiata Limited, Shanghai Infoservice Technology Co. Ltd, Shanghai Sihua Technologies Co. Ltd, Sistema de Aguas de la Ciudad de M_xico, Solihull Metropolitan Borough Council, Suddenlink Communications, Suprajit Engineering Limited, Tallink Grupp, Terminales Ro de la Plata S.A., Therap Services LLC, Think Passenger Inc., Trafigura, Transmed S.A.L Lebanon, ValeShop, VelQuest Corporation, Vodafone Group plc, West Virginia Network, WIND Hellas Telecommunications S.A
    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.
    Top Industries
    REVIEWERS
    Financial Services Firm17%
    Computer Software Company15%
    Government8%
    Comms Service Provider7%
    VISITORS READING REVIEWS
    Computer Software Company30%
    Comms Service Provider18%
    Financial Services Firm11%
    Government6%
    REVIEWERS
    Financial Services Firm18%
    Computer Software Company13%
    Manufacturing Company11%
    Comms Service Provider5%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider22%
    Financial Services Firm7%
    Government5%
    Company Size
    REVIEWERS
    Small Business23%
    Midsize Enterprise22%
    Large Enterprise55%
    REVIEWERS
    Small Business43%
    Midsize Enterprise21%
    Large Enterprise36%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    Find out what your peers are saying about Oracle Database vs. SQL Server and other solutions. Updated: January 2022.
    565,689 professionals have used our research since 2012.

    Oracle Database is ranked 2nd in Relational Databases with 125 reviews while SQL Server is ranked 1st in Relational Databases with 145 reviews. Oracle Database is rated 8.4, while SQL Server is rated 8.2. The top reviewer of Oracle Database writes "Gets the job done, doesn't fail, and suitable for massively scalable applications". On the other hand, the top reviewer of SQL Server writes "Veteran solution with critical log shipping feature". Oracle Database is most compared with SAP HANA, IBM Db2 Database, MySQL, MariaDB and Teradata, whereas SQL Server is most compared with SAP HANA, LocalDB, IBM Db2 Database, Teradata and MariaDB. See our Oracle Database vs. SQL Server report.

    See our list of best Relational Databases vendors.

    We monitor all Relational Databases 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.