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





Comments For This Article





download


Recommended Reading

SQL Server and PostgreSQL Linked Server Configuration - Part 2

Creating a SQL Server 2014 Linked Server for an Oracle 11g Database

SQL Server and PostgreSQL Foreign Data Wrapper Configuration - Part 3

Transferring Data Between SQL Server 2014 and Oracle 11g Databases

Export Data from IBM DB2 iSeries to SQL Server





get free sql tips
agree to terms


Learn more about SQL Server tools