Migrating to MariaDB from SQL Server

This section is a guide to help you migrate from SQL Server to MariaDB. This includes a general understanding of MariaDB, information to help plan the migration, and differences in the configuration and syntax.

Title Description
Understanding MariaDB Architecture An overview of MariaDB server architecture, especially where it differs from SQL Server.
SQL Server Features Not Available in MariaDB List of SQL Server features not available in MariaDB.
SQL Server Features Implemented Differently in MariaDB List of SQL Server features that MariaDB implements in a different way.
MariaDB Features Not Available in SQL Server List of MariaDB features not available in SQL Server.
Setting Up MariaDB for Testing for SQL Server Users Hints for SQL Server users to setup MariaDB for testing.
Syntax Differences between MariaDB and SQL Server MariaDB syntax hints for SQL Server users.
SQL Server and MariaDB Types Comparison Comparison tables between SQL Server types and MariaDB types.
MariaDB Transactions and Isolation Levels for SQL Server Users How MariaDB transactions and isolation levels differ from SQL Server.
MariaDB Authorization and Permissions for SQL Server Users MariaDB handles users and permissions quite differently to SQL Server.
Repairing MariaDB Tables for SQL Server Users MariaDB table repair explained to SQL Server users.
MariaDB Backups Overview for SQL Server Users An overview of MariaDB backup tools and techniques for SQL Server users.
MariaDB Replication Overview for SQL Server Users An overview of MariaDB replication types for SQL Server users.
Moving Data Between SQL Server and MariaDB Information and some advice on how to import SQL Server data into MariaDB.
SQL_MODE=MSSQL Microsoft SQL Server compatibility mode.
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.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/migrating-to-mariadb-from-sql-server/