By: Daniel Calbimonte | Updated: 2015-03-13 | Comments (1) | Related: > 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:
|
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:
|
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
- For more information on SQL Server and MariaDB, refer to the following:
About the author
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
Article Last Updated: 2015-03-13
