Try our new research platform with insights from 80,000+ expert users
2017-06-26T14:11:00Z

SQL Server vs Oracle Database vs MySQL

it_user326337 - PeerSpot reviewer
  • 157
Published:Jun 26, 2017
Explore related topics
Product comparison that may be of interest to you
PeerSpot user
3

3 Comments

НЕ
Real User
2018-01-05T09:29:28Z
Jan 5, 2018
it_user514683 - PeerSpot reviewer
Consultant
2017-09-13T18:17:23Z
Sep 13, 2017
it_user699492 - PeerSpot reviewer
Consultant
2017-07-09T11:55:16Z
Jul 9, 2017
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: October 2024.
814,763 professionals have used our research since 2012.
Related Questions
SR
Oct 5, 2023
Oct 5, 2023
Your decision should ideally be based on: - The specific needs and existing infrastructure of your organization. - Cost considerations. - Desired features and potential future scaling. - Expertise available within your organization or your hiring intentions. I can provide a comparison based on the characteristics of Microsoft SQL Server's Enterprise Edition and Oracle Database's Enterprise Edit...
See 2 answers
PG
Oct 2, 2023
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!
Abdellateef Hasan - PeerSpot reviewer
Oct 5, 2023
Your decision should ideally be based on: - The specific needs and existing infrastructure of your organization. - Cost considerations. - Desired features and potential future scaling. - Expertise available within your organization or your hiring intentions. I can provide a comparison based on the characteristics of Microsoft SQL Server's Enterprise Edition and Oracle Database's Enterprise Edition: 1. Licensing and Cost: - SQL Server: Historically, SQL Server has been considered to be more cost-effective than Oracle. Microsoft offers both core-based and CAL (Client Access License) based licensing options. - Oracle: Oracle is often perceived as more expensive, with its licensing based primarily on cores (with considerations for hyper-threading). There are also additional costs for add-on features which might be included in other platforms. 2. Platform Integration: - SQL Server: Tends to have better integration with other Microsoft products like Windows OS, .NET, Azure, etc. - Oracle: Oracle offers a wide range of integrated tools, but the integration might not be as smooth with non-Oracle products. 3. Performance: - Both databases are enterprise-grade and offer high performance, but the actual performance can depend on the specific use-case, database design, hardware, and many other factors. 4. Features: - SQL Server: SQL Server offers features like Always On Availability Groups, Columnstore Indexes, and integration with tools like Power BI. - Oracle: Offers advanced features like Real Application Clusters (RAC), Exadata optimizations, Advanced Compression, Partitioning, etc. Some of these features, however, come with additional licensing costs. 5. Ease of Use: - SQL Server: Often considered more user-friendly, especially for those organizations already embedded in the Microsoft ecosystem. - Oracle: Might have a steeper learning curve, but offers flexibility and depth for those familiar with it. 6. Cloud Integration: - SQL Server: Has tight integration with Azure, Microsoft's cloud solution. - Oracle: Oracle Cloud offers various services tailored to the Oracle Database, and the company has been pushing its cloud services aggressively.
NC
Dec 18, 2022
Dec 18, 2022
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos online. But now Oracle owns it, and they are well-known for their Oracle University and extensive courses. So it makes absolutely no sense how complex the guides for MySQL still are! Someone just beginnin...
See 2 answers
Deena Nouril - PeerSpot reviewer
Dec 18, 2022
I use the open-source version of MySQL so if I want to fix something, I do it straight in the code. I cannot name a particular flaw with the solution or something fundamental that must be changed. However, I need to note how useful it is that Oracle kept a free version of this product. It is understandable why they bought it - they are a big data company and MySQL was the best free solution out there. I hear from the community that they fix things within the product in a timely manner and continuously update and upgrade it. But keeping the free version is useful for them too, as people like me can point out bugs that they may not see and fix them.
Dec 18, 2022
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos online. But now Oracle owns it, and they are well-known for their Oracle University and extensive courses. So it makes absolutely no sense how complex the guides for MySQL still are! Someone just beginning to use this solution will have no clue how to do it - it is very hard to grasp based solely on the official documentation. I hope they improve this in the future. It will be helpful for their customer support too, as it will save them time from having to answer user questions.
Related Articles
Umair Hassan - PeerSpot reviewer
Jan 19, 2023
Jan 19, 2023
In my previous article, I looked into the process of enabling MySQL keyring encryption, which is a complex topic, so I divided it into multiple articles. We can use keyring encryption to encrypt the physical files of the database, but what if we also want to encrypt the data stored in our tables? Fortunately, MySQL allows us to store data in an encrypted form, which we will discuss in t...
Umair Hassan - PeerSpot reviewer
Dec 28, 2022
Dec 28, 2022
Percona MySQL Encryption is a powerful tool that ensures data security and privacy. It is an open source solution that provides encryption for the MySQL database. Percona provides a variety of encryption options for users to choose from, and it is easy to implement and maintain. In this article, We will try to learn step by step about MySQL keyring encryption. OS Version: "Ubuntu 20.0...
Product Comparisons
Related Categories
Related Articles
Umair Hassan - PeerSpot reviewer
Jan 19, 2023
Encrypting Percona MySQL Keyring - A Step-By-Step Guide - Part Two
In my previous article, I looked into the process of enabling MySQL keyring encryption, which ...
Umair Hassan - PeerSpot reviewer
Dec 28, 2022
Encrypting Percona MySQL Keyring - A Step-By-Step Guide
Percona MySQL Encryption is a powerful tool that ensures data security and privacy. It is an open...
Download Free Report
Download our free Relational Databases Tools Report and find out what your peers are saying about Oracle, Microsoft, IBM, and more! Updated: October 2024.
DOWNLOAD NOW
814,763 professionals have used our research since 2012.