mssqltips logo

Compare SQL Server and MariaDB Operational Technology

By:   |   Updated: 2015-03-13   |   Comments   |   Related: More > Other Database Platforms

Problem

In part 1, part 2 and part 3 of this series, I compared SQL commands for MariaDB and SQL Server.  In this tip, we will review some of the operational items related to the database platforms.

Solution

Replication Support in SQL Server vs. MariaDB

SQL Server

MariaDB

There are several options available.  These technologies include:

MariaDB has Standard Replication solution with master server(s) and slave mirror(s). There is also MariaDB Galera Cluster which is an Active-Active solution, but only available for Linux.

How to Migrate data to other Databases (Oracle, DB2, etc.)

SQL Server

MariaDB

There are a few different options.  These include:

You will need third party tools like Upscene or Navicat Premium.

Operating Systems Supported by SQL Server vs. MariaDB

SQL Server

MariaDB

SQL Server is only supported on Windows.

MariaDB supports the following operating systems:

  • Windows
  • Linux
  • UNIX
  • OS X
  • Solaris
  • BSD

Prices for SQL Server vs. MariaDB

SQL Server

MariaDB

Pricing depends on the Edition of SQL Server. For more information, use this link. SQL Server Express is a free edition.

 

GNU license (free distribution), but you have to pay for technical support. For more information about tech support prices, use this link.

Versions of SQL Server vs. MariaDB

SQL Server

MariaDB

SQL Server 2014, 2012, 2008, 2005, 2000, 7.0, 6.5, 6.0, 4.21, 1.1, 1.0.

 

MariaDB 10.1, 10.0, 5.5, 5.3, 5.2 and 5.1.

Editions of SQL Server vs. MariaDB

SQL Server

MariaDB

SQL Server Enterprise, Standard, Business Intelligence, Developer, Express (free edition). Learn more.

Mariadb Enterprise Mariadb Enterprise Cluster is a solution for Mariadb Enterprise for High Availability and Mariadb MaxScale helps you to extend the scalability.

How to work with Clusters in SQL Server vs. MariaDB

SQL Server
MariaDB

There are two options:

You can use Mariadb Enterprise Cluster

Index Types in SQL Server vs. MariaDB

SQL Server

MariaDB

SQL Server supports the following indexes:

MariaDB supports B-tree Indexes, Hash Indexes, R-tree Indexes (spatial).

Other classification is Primary Keys, Unique indexes, plain indexes and Fulltext Indexes.

Reporting Tools in SQL Server vs. MariaDB

SQL Server

MariaDB

SQL Server supports:

  • SQL Server Reporting Services (SSRS).  Learn more.
  • You can also publish your reports in SharePoint (distributed separately).  Learn more.
  • There is a nice plugin for SharePoint named Powerview to create very powerful and dynamic reports.

MariaDB supports tools like Navicat for MariaDB, JPDB Admin for Mariadb, Valentina Studio.

How to Store Large Files (images, pdf files, etc.) in SQL Server vs. MariaDB

SQL Server

MariaDB

SQL Server supports: Filestream at the database level.  Learn more.

MariaDB supports blob data types.

UI Tools to Administer SQL Server vs. MariaDB

SQL Server

MariaDB

SQL Server supports:

MariaDB supports tools like: HeidiSQL (it comes with the MariaDB installer), DBEdit, Navicat, Database Workbench, SQLyog, etc.

Next Steps


Last Updated: 2015-03-13


get scripts

next tip button



About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools