We performed a comparison between MariaDB 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: MariaDB is the winner when it comes to ease of use, initial setup and price. SQL Server comes out on top when it comes to performance, scalability, and support.
"We like the easy way that we can collect data from other databases."
"MariaDB is easy to install and is stable and scalable."
"From the user's perspective, the performance of the columnar queries is very good in terms of the database when comparing it to the Oracle, and MySQL."
"The product has good documentation and you can find many examples online."
"The solution runs very quickly. It's not slow at all."
"The solution has PL/SQL compatibility."
"I like the global transaction IDs (GTIDs) feature. It's quite reliable for replication between a master and a replica server, and it's a feature that MySQL also has but implemented differently."
"One of the great features of MariaDB is its scalability. It's easy to handle even with large databases."
"I have contacted technical support, and overall my experience with technical support was okay."
"The ease of administration, in general, is the solution's most valuable aspect."
"SQL Server is quite stable. And now we are using the Lattice 2017 version."
"We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables."
"It is one of the most stable relational databases out there."
"The interface for building the queries or writing the store procedures is good."
"The initial setup isn't overly complex."
"The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful."
"The difficult part related to the product stems not from the tool itself but is related to learning how to implement the product in the right way without creating any wrong configuration that could cause security issues or performance issues."
"One feedback I can quickly provide is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively."
"Maria DB has to improve from a management perspective."
"The price could be less expensive."
"Document caching is an area of concern in the product, where improvements are required to help MariaDB improve on the previous queries as they are retained, and you can roll back to them."
"Could have more integration with user platforms."
"Replication could be better, and it's not so simple. It would be better if they had a replication server. It would make things a lot easier. You need to have that replication server, but not in the same server farm. Then there will be a bit of latency between both because you should have one in one city and another one in a different city. That kind of solution should be more baked into every single database today. Mirroring the database in a live environment where any record written on the production server replicates instantly across the fiber on the other server wasn't easy. Many people don't even bother with that, and they just run one server."
"MariaDB could improve by adding support for non-relational structures and new data types."
"The tool's support needs to be improved."
"Sometimes we experience issues with its stability."
"Indexing, as well as integration, are areas of this product that need improvement."
"We have no vision. We don't know when or how we have been hacked."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"Since this is a relational order system, scalability has a limit. If your system is very big, you need bigger servers and you have to spend more money. We scale a system up to a certain level, and then we move or shift data to the warehouse, which is NoSQL. We then do not have any bottleneck in scaling. For using this technique we are happy with it."
"Debugging from the debugger tool functionality should be enhanced."
"The performance needs some improvement and it needs more features integrated into it."
MariaDB is ranked 5th in Relational Databases Tools with 52 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. MariaDB is rated 8.2, while SQL Server is rated 8.4. The top reviewer of MariaDB writes "Easy to deploy, cost-effective, and integrates seamlessly with other products". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". MariaDB is most compared with Oracle Database, Firebird SQL, PostgreSQL, MySQL and Percona Server, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, IBM Db2 Database and Teradata. See our MariaDB 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.
