MariaDB Features Not Available in SQL Server
You are viewing an old version of this article. View
the current version here.
Migrating from SQL Server? Contact the MariaDB migration experts!
Contact UsSome MariaDB features are not available in SQL Server.
At a first glance, it is not important to know about those features to migrate from SQL Server to MariaDB. However, this is not the case. Using MariaDB features that are not in SQL Server allows one to obtain more advantages from the migration, getting the most from MariaDB.
This page has a list of MariaDB features that are not supported in SQL Server. The list is not exhaustive.
Plugin Architecture
- Storage engines.
- Authentication plugins.
- Encryption plugins.
- ColumnStore is a columnar storage engine designed to scale horizontally. It runs on a specific edition of MariaDB, so currently it cannot be used in combination with other engines.
SQL
- The sql_mode variable determines in which cases an SQL statements should fail with an error, and in which cases it should succeed with a warning even if it is not entirely correct. For example, when a statement tries to insert a string in a column which is not big enough to contain it, it could fail, or it could insert a truncated string and emit a warning. It is a tradeoff between reliability and flexibility.
- SQL_MODE=MSSQL allows to use a small subset of SQL Server proprietary syntax.
CREATE ... IF EXISTS
,CREATE OR REPLACE
,DROP ... IF NOT EXISTS
options are supported for most DDL statements.- CHECKSUM TABLE statement.
- PL/SQL support (only for stored procedures and stored functions).
- Row constructors.
BEFORE
triggers.
Types
- Character sets and collations don't depend on column type. They can be set globally, or at database, table or column level.
- Columns may use non-constant expressions as
DEFAULT
value.TIMESTAMP
columns may have aDEFAULT
value. UNSIGNED
numeric types.- Dynamic columns (note that JSON is usually preferred to this feature).
Features
- Flashback functionality allows one to "undo" the changes that happened since a certain point in time.
- Tables can be partitioned based on multiple columns.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.